public static bool Update(Locality info)
{
if (info.VillageId != 0)
{
return(BaseDataAccess.ExecuteSQL(String.Format("update Localities set CityId='{0}', VillageId='{1}', Name='{2}', PinCode='{3}', Latitude='{4}', Longitude='{5}' where Id='{6}' ", info.CityId, info.VillageId, info.Name, info.Pincode, info.Latitude, info.Longitude, info.Id)));
}
else
{
return(BaseDataAccess.ExecuteSQL(String.Format("update Localities set CityId='{0}', Name='{1}', PinCode='{2}', Latitude='{3}', Longitude='{4}' where Id='{5}' ", info.CityId, info.Name, info.Pincode, info.Latitude, info.Longitude, info.Id)));
}
}
public static bool Add(Locality info)
{
if (info.VillageId != 0)
{
return(BaseDataAccess.ExecuteSQL(String.Format("insert into Localities(CityId, VillageId, Name, PinCode, Latitude, Longitude) values('{0}', '{1}', '{2}', '{3}', '{4}', '{5}' ) ", info.CityId, info.VillageId, info.Name, info.Pincode, info.Latitude, info.Longitude)));
}
else
{
return(BaseDataAccess.ExecuteSQL(String.Format("insert into Localities(CityId, Name, PinCode, Latitude, Longitude) values('{0}', '{1}', '{2}', '{3}', '{4}' ) ", info.CityId, info.Name, info.Pincode, info.Latitude, info.Longitude)));
}
}
public static bool Add(DepartmentXAreaOnDuty info)
{
if (info.VillageId == 0)
{
return(BaseDataAccess.ExecuteSQL(String.Format("insert into DepartmentXAreaOnDuty(DepartmentId, StateId, CityId,LocalityId, OnDutyPersonId, DutyTimeFrom, DutyTimeTo)values('{0}','{1}','{2}','{3}','{4}','{5}','{6}')", info.DepartmentId, info.StateId, info.CityId, info.LocalityId, info.OnDutyPersonId, info.DutyTimeFrom.ToShortTimeString(), info.DutyTimeTo.ToShortTimeString())));
}
else
{
return(BaseDataAccess.ExecuteSQL(String.Format("insert into DepartmentXAreaOnDuty(DepartmentId, StateId, CityId,VillageId,LocalityId, OnDutyPersonId, DutyTimeFrom, DutyTimeTo)values('{0}','{1}','{2}','{3}','{4}','{5}','{6}','{7}')", info.DepartmentId, info.StateId, info.CityId, info.VillageId, info.LocalityId, info.OnDutyPersonId, info.DutyTimeFrom.ToShortTimeString(), info.DutyTimeTo.ToShortTimeString())));
}
}
public static bool Add(Department info)
{
if (info.VillageId != 0)
{
return(BaseDataAccess.ExecuteSQL(String.Format("insert into Departments(DepartmentTypeId, Name, StateId, CityId, VillageId, LocalityId, OfficeAddress, Website, ContactEmails, ContactNumbers, ContactTimings) values('{0}','{1}','{2}','{3}','{4}','{5}','{6}','{7}','{8}','{9}','{10}')", info.DepartmentTypeId, info.Name, info.StateId, info.CityId, info.VillageId, info.LocalityId, info.OfficeAddress, info.Website, info.ContactEmails, info.ContactNumbers, info.ContactTimings)));
}
else
{
return(BaseDataAccess.ExecuteSQL(String.Format("insert into Departments(DepartmentTypeId, Name, StateId, CityId, LocalityId, OfficeAddress, Website, ContactEmails, ContactNumbers, ContactTimings) values('{0}','{1}','{2}','{3}','{4}','{5}','{6}','{7}','{8}','{9}')", info.DepartmentTypeId, info.Name, info.StateId, info.CityId, info.LocalityId, info.OfficeAddress, info.Website, info.ContactEmails, info.ContactNumbers, info.ContactTimings)));
}
}
public static bool Update(Complaint info)
{
if (info.VillageId == 0)
{
return(BaseDataAccess.ExecuteSQL(String.Format("Update Complaints set StateId='{0}',CityId='{1}',LocalityId='{2}',DepartmentTypeId='{3}',ComplaintTypeId='{4}', ReportingPersonFirstName='{5}',ReportingPersonLastName='{6}',ReportingPersonAdhaarId='{7}',ReportingPersonContactNumber='{8}',ReportingTime='{9}', CurrentStatusId='{10}', CurrentEscalationNumber='{11}', OTP='{12}', ComplaintVerifiedViaOTP='{13}', IsEscalated='{14}', DepartmentId='{15}' where Id='{16}'", info.StateId, info.CityId, info.LocalityId, info.DepartmentTypeId, info.ComplaintTypeId, info.ReportingPersonFirstName, info.ReportingPersonLastName, info.ReportingPersonAdhaarId, info.ReportingPersonContactNumber, info.ReportingTime, info.CurrentStatusId, info.CurrentEscalationNumber, info.OTP, info.ComplaintVerifiedViaOTP, info.IsEscalated, info.DepartmentId, info.Id)));
}
else
{
return(BaseDataAccess.ExecuteSQL(String.Format("Update Complaints set StateId='{0}',CityId='{1}',VillageId='{2}',LocalityId='{3}',DepartmentTypeId='{4}',ComplaintTypeId='{5}', ReportingPersonFirstName='{6}',ReportingPersonLastName='{7}',ReportingPersonAdhaarId='{8}',ReportingPersonContactNumber='{9}',ReportingTime='{10}', CurrentStatusId='{11}', CurrentEscalationNumber='{12}', OTP='{13}', ComplaintVerifiedViaOTP='{14}', IsEscalated='{15}', DepartmentId='{16}' where Id='{17}'", info.StateId, info.CityId, info.VillageId, info.LocalityId, info.DepartmentTypeId, info.ComplaintTypeId, info.ReportingPersonFirstName, info.ReportingPersonLastName, info.ReportingPersonAdhaarId, info.ReportingPersonContactNumber, info.ReportingTime, info.CurrentStatusId, info.CurrentEscalationNumber, info.OTP, info.ComplaintVerifiedViaOTP, info.IsEscalated, info.DepartmentId, info.Id)));
}
}
public static bool Update(Department info)
{
if (info.VillageId != 0)
{
return(BaseDataAccess.ExecuteSQL(String.Format("update Departments set DepartmentTypeId='{0}', Name='{1}', StateId='{2}',CityId='{3}',VillageId='{4}',LocalityId='{5}',OfficeAddress='{6}',Website='{7}',ContactEmails='{8}',ContactNumbers='{9}', ContactTimings='{10}' where Id='{11}'", info.DepartmentTypeId, info.Name, info.StateId, info.CityId, info.VillageId, info.LocalityId, info.OfficeAddress, info.Website, info.ContactEmails, info.ContactNumbers, info.ContactTimings, info.Id)));
}
else
{
return(BaseDataAccess.ExecuteSQL(String.Format("update Departments set DepartmentTypeId='{0}', Name='{1}', StateId='{2}',CityId='{3}',LocalityId='{4}',OfficeAddress='{5}',Website='{6}',ContactEmails='{7}',ContactNumbers='{8}', ContactTimings='{9}' where Id='{10}'", info.DepartmentTypeId, info.Name, info.StateId, info.CityId, info.LocalityId, info.OfficeAddress, info.Website, info.ContactEmails, info.ContactNumbers, info.ContactTimings, info.Id)));
}
}
public static bool Update(DepartmentXAreaOnDuty info)
{
if (info.VillageId == 0)
{
return(BaseDataAccess.ExecuteSQL(String.Format("update DepartmentXAreaOnDuty set DepartmentId='{0}', StateId='{1}', CityId='{2}', VillageId='{3}',LocalityId='{4}', OnDutyPersonId='{5}',DutyTimeFrom='{6}',DutyTimeTo='{7}' where Id='{8}'", info.DepartmentId, info.StateId, info.CityId, info.VillageId, info.LocalityId, info.OnDutyPersonId, info.DutyTimeFrom.ToShortTimeString(), info.DutyTimeTo.ToShortTimeString(), info.Id)));
}
else
{
return(BaseDataAccess.ExecuteSQL(String.Format("update DepartmentXAreaOnDuty set DepartmentId='{0}', StateId='{1}', CityId='{2}', VillageId='{3}',LocalityId='{4}', OnDutyPersonId='{5}',DutyTimeFrom='{6}',DutyTimeTo='{7}' where Id='{8}'", info.DepartmentId, info.StateId, info.CityId, info.VillageId, info.LocalityId, info.OnDutyPersonId, info.DutyTimeFrom.ToShortTimeString(), info.DutyTimeTo.ToShortTimeString(), info.Id)));
}
}
public static bool Add(DepartmentXAreaIncharge info)
{
if (info.VillageId != 0)
{
return(BaseDataAccess.ExecuteSQL(String.Format("insert into DepartmentXAreaIncharges(DepartmentId, StateId, CityId,VillageId,LocalityId, InchargeId)values('{0}','{1}','{2}','{3}','{4}','{5}')", info.DepartmentId, info.StateId, info.CityId, info.VillageId, info.LocalityId, info.InchargeId)));
}
else
{
return(BaseDataAccess.ExecuteSQL(String.Format("insert into DepartmentXAreaIncharges(DepartmentId, StateId, CityId,LocalityId, InchargeId)values('{0}','{1}','{2}','{3}','{4}')", info.DepartmentId, info.StateId, info.CityId, info.LocalityId, info.InchargeId)));
}
}
public static bool Update(DepartmentXAreaIncharge info)
{
return(BaseDataAccess.ExecuteSQL(String.Format("update DepartmentXAreaIncharges set DepartmentId='{0}',StateId='{1}',CityId='{2}',VillageId='{3}',LocalityId='{4}',InchargeId='{5}' where Id='{6}'", info.DepartmentId, info.StateId, info.CityId, info.VillageId, info.LocalityId, info.InchargeId, info.Id)));
}
public static bool Delete(Village info)
{
return(BaseDataAccess.ExecuteSQL(String.Format("delete from Villages where Id='{0}'", info.Id)));
}
public static bool Update(Village info)
{
return(BaseDataAccess.ExecuteSQL(String.Format("update Villages set CityId='{0}',Name='{1}', PinCode='{2}' where Id='{3}'", info.CityId, info.Name, info.PinCode, info.Id)));
}
public static bool Add(Village info)
{
return(BaseDataAccess.ExecuteSQL(String.Format("insert into Villages(CityId, Name, PinCode)values('{0}','{1}','{2}')", info.CityId, info.Name, info.PinCode)));
}
public static bool Delete(GovernmentOfficial info)
{
return(BaseDataAccess.ExecuteSQL(String.Format("delete from GovernmentOfficials where Id='{0}'", info.Id)));
}
public static bool Update(DepartmentEscalationLevel info)
{
return(BaseDataAccess.ExecuteSQL(String.Format("update DepartmentEscalationLevels set DepartmentId='{0}', EscalationLevelName='{1}', DesignatedOfficialId='{2}', LevelNumber='{3}' where Id='{4}'", info.DepartmentId, info.EscalationLevelName, info.DesignatedOfficialId, info.LevelNumber, info.Id)));
}
public static bool Delete(AdhaarXOTP info)
{
return(BaseDataAccess.ExecuteSQL(String.Format("delete from AdhaarXOTP where Id='{0}' ", info.Id)));
}
public static bool Add(AdhaarXContactNumber info)
{
return(BaseDataAccess.ExecuteSQL(String.Format("insert into AdhaarXContactNumber(AdhaarNumber, ContactNumber) values('{0}', '{1}') ", info.AdhaarNumber, info.ContactNumber)));
}
public static bool Add(DepartmentXOfficial info)
{
return(BaseDataAccess.ExecuteSQL(String.Format("insert into DepartmentXOfficials (DepartmentId, GovernmentOfficialId, DesignationId) values('{0}','{1}','{2}')", info.DepartmentId, info.GovernmentOfficialId, info.DesignationId)));
}
public static bool Update(State info)
{
return(BaseDataAccess.ExecuteSQL(String.Format("update states set Name = '{0}' where Id='{1}' ", info.Name, info.Id)));
}
public static bool Add(State info)
{
return(BaseDataAccess.ExecuteSQL(String.Format("insert into states(Name) values('{0}') ", info.Name)));
}
public static bool Delete(DepartmentEscalationLevel info)
{
return(BaseDataAccess.ExecuteSQL(String.Format("delete from DepartmentEscalationLevels where Id='{0}'", info.Id)));
}
public static bool Add(AdhaarXOTP info)
{
return(BaseDataAccess.ExecuteSQL(String.Format("insert into AdhaarXOTP(AdhaarNumber, OTP) values('{0}', '{1}') ", info.AdhaarNumber, info.OTP)));
}
public static bool Update(ComplaintType info)
{
return(BaseDataAccess.ExecuteSQL(String.Format("update ComplaintTypes set Name='{1}',DepartmentTypeId='{2}'where Id={3}", info.Name, info.DepartmentTypeId, info.Id)));
}
public static bool Update(AdhaarXOTP info)
{
return(BaseDataAccess.ExecuteSQL(String.Format("update AdhaarXOTP set AdhaarNumber='{0}', OTP='{1}' where Id='{2}' ", info.AdhaarNumber, info.OTP, info.Id)));
}
public static bool Add(DepartmentEscalationLevel info)
{
return(BaseDataAccess.ExecuteSQL(String.Format("insert into DepartmentEscalationLevels(DepartmentId,EscalationLevelName, DesignatedOfficialId, LevelNumber) values('{0}','{1}','{2}','{3}')", info.DepartmentId, info.EscalationLevelName, info.DesignatedOfficialId, info.LevelNumber)));
}
public static bool Update(DepartmentXOfficial info)
{
return(BaseDataAccess.ExecuteSQL(String.Format("update DepartmentXOfficials set DepartmentId='{0}',GovernmentOfficialId='{1}', DesignationId='{2}'where Id='{3}'", info.DepartmentId, info.GovernmentOfficialId, info.DesignationId, info.Id)));
}
public static bool Add(ComplaintType info)
{
return(BaseDataAccess.ExecuteSQL(String.Format("insert into ComplaintTypes( Name, DepartmentTypeId) values('{0}','{1}')", info.Name, info.DepartmentTypeId)));
}
public static bool Delete(DepartmentXAreaOnDuty info)
{
return(BaseDataAccess.ExecuteSQL(String.Format("delete from DepartmentXAreaOnDuty where Id='{0}'", info.Id)));
}
public static bool Add(GovernmentOfficial info)
{
return(BaseDataAccess.ExecuteSQL(String.Format("insert into GovernmentOfficials(Name, ContactNumber, ContactEmail, Picture, DesignationId, OfficialCode) values('{0}', '{1}', '{2}', '{3}', '{4}', '{5}') ", info.Name, info.ContactNumber, info.ContactEmail, info.Picture, info.DesignationId, info.OfficialCode)));
}
public static bool Delete(Complaint info)
{
return(BaseDataAccess.ExecuteSQL(String.Format("Delete from Complaints where Id='{0}'", info.Id)));
}
public static bool Update(GovernmentOfficial info)
{
return(BaseDataAccess.ExecuteSQL(String.Format("update GovernmentOfficials set Name='{0}', ContactNumber='{1}', ContactEmail='{2}', Picture='{3}', DesignationId='{4}', OfficialCode='{5}' where Id='{6}'", info.Name, info.ContactNumber, info.ContactEmail, info.Picture, info.DesignationId, info.OfficialCode, info.Id)));
}