package Ġcom . app . vx resume builder . data . repository . offline . dao Ċ Ċ import Ġandroidx . room . Dao Ċ import Ġandroidx . room . Insert Ċ import Ġandroidx . room . On Conflict Strategy Ċ import Ġandroidx . room . Query Ċ import Ġcom . app . vx resume builder . data . dto . entity . Information Data Ċ import Ġcom . app . vx resume builder . data . dto . entity . Personal Information Ċ import Ġcom . app . vx resume builder . data . dto . entity . Resume Ċ import Ġcom . app . vx resume builder . data . dto . enum const . Category Ċ import Ġcom . app . vx resume builder . data . dto . enum const . Progress Status Ċ Ċ @ Dao Ċ interface ĠV x Resume Builder Dao Ġ{ ĊĠĠĠ Ġ@ Insert ( on Conflict Ġ= ĠOn Conflict Strategy . REPLACE ) ĊĠĠĠ Ġfun Ġinsert Resume Data ( resume : ĠResume ): ĠLong ĊĊĠĠĠ Ġ@ Insert ( on Conflict Ġ= ĠOn Conflict Strategy . REPLACE ) ĊĠĠĠ Ġfun Ġinsert Personal Data ( personal Information : ĠPersonal Information ): ĠLong ĊĊĠĠĠ Ġ@ Query (" SELECT Ġ* ĠFROM Ġresume ") ĊĠĠĠ Ġfun Ġget Resume List (): ĠList < Resume > ĊĊĠĠĠ Ġ@ Query (" DELETE Ġ ĠFROM Ġresume ĠWHERE Ġid =: resume Id ") ĊĠĠĠ Ġfun Ġremove Resume ById ( resume Id : ĠLong ): ĠInt ĊĊĠĠĠ Ġ@ Query (" UPDATE Ġresume ĠSET Ġname =: title ĠWHERE Ġid =: resume Id ") ĊĠĠĠ Ġfun Ġupdate Resume ById ( resume Id : ĠLong , Ġtitle : ĠString ): ĠInt ĊĊĠĠĠ Ġ@ Query (" UPDATE Ġresume ĠSET Ġstatus =: status ĠWHERE Ġid =: resume Id ") ĊĠĠĠ Ġfun Ġupdate Resume Status ( resume Id : ĠLong , Ġstatus : ĠProgress Status ): ĠInt ĊĊĠĠĠ Ġ@ Query (" SELECT Ġ* ĠFROM Ġpersonal information ĠWHERE Ġresume Id =: resume Id ") ĊĠĠĠ Ġfun Ġget Personal Id From Resume Id ( resume Id : ĠLong ): ĠPersonal Information ĊĊĠĠĠ Ġ@ Query (" UPDATE Ġpersonal information ĠSET ĠfullName =: fullName , email =: email , phoneNumber =: mobile Number , address =: address , profile Picture Ġ= : profile Picture ĠWHERE Ġresume Id =: resume Id ") ĊĠĠĠ Ġfun Ġupdate Personal Information ( fullName : ĠString , Ġemail : ĠString , Ġmobile Number : ĠString , Ġaddress : ĠString , Ġresume Id : ĠLong , Ġprofile Picture : ĠString ): ĠInt ĊĊĠĠĠ Ġ@ Query (" SELECT Ġ* ĠFROM Ġinformation data ĠWHERE Ġresume _ id =: resume Id ĠAND Ġcategory =: category ") ĊĠĠĠ Ġfun Ġget Existing Information Data By Resume Id ( resume Id : ĠLong , Ġcategory : ĠCategory ): ĠList < Information Data > ĊĊĠĠĠ Ġ@ Query (" SELECT Ġ* ĠFROM Ġinformation data ĠWHERE Ġinformation _ data _ id =: id ") ĊĠĠĠ Ġfun Ġget Detail Information Data ById ( id : ĠInt ): ĠInformation Data ĊĊĠĠĠ Ġ@ Insert ( on Conflict Ġ= ĠOn Conflict Strategy . REPLACE ) ĊĠĠĠ Ġfun Ġinsert Information Data ( personal Information : ĠInformation Data ): ĠLong ĊĊĠĠĠ Ġ@ Query (" DELETE Ġ ĠFROM Ġinformation data ĠWHERE Ġinformation _ data _ id =: id ") ĊĠĠĠ Ġfun Ġremove Information Data Id ( id : ĠInt ): ĠInt ĊĊĠĠĠ Ġ@ Query (" UPDATE Ġinformation data ĠSET Ġtitle =: education School , description =: completion Year , g pa =: g pa , grade =: grade ĠWHERE Ġinformation _ data _ id =: information Data Id ") ĊĠĠĠ Ġfun Ġupdate Education Info ( information Data Id : ĠInt , Ġeducation School : ĠString , Ġcompletion Year : ĠString , Ġg pa : ĠString , Ġgrade : ĠString ): ĠInt ĊĊĠĠĠ Ġ@ Query (" UPDATE Ġinformation data ĠSET Ġtitle =: project Title , client name =: client Name , duration =: duration , description =: description , is Current =: is Current ĠWHERE Ġinformation _ data _ id =: information Data Id ") ĊĠĠĠ Ġfun Ġupdate Project Info ( information Data Id : ĠInt , Ġproject Title : ĠString , Ġclient Name : ĠString , Ġduration : ĠString , Ġdescription : ĠString , Ġis Current : ĠBoolean ): ĠInt ĊĊĠĠĠ Ġ@ Query (" UPDATE Ġinformation data ĠSET Ġtitle =: company Name , position =: position , duration =: duration , description =: description , is Current =: is Current ĠWHERE Ġinformation _ data _ id =: information Data Id ") ĊĠĠĠ Ġfun Ġupdate Work Info ( information Data Id : ĠInt , Ġcompany Name : ĠString , Ġposition : ĠString , Ġduration : ĠString , Ġdescription : ĠString , Ġis Current : ĠBoolean ): ĠInt Ċ } Ċ