public static function update($obj_Agriculture)
{
$db = config::dbconfig();
$obj_retresult = new returnResult();
try {
$sql = "UPDATE tbl_Agriculture SET " . "AgricultureId=" . common::noSqlInject($obj_Agriculture->AgricultureId) . "," . "AgricultureName=" . "'" . common::noSqlInject($obj_Agriculture->AgricultureName) . "'" . "," . "Description=" . "'" . common::noSqlInject($obj_Agriculture->Description) . "'" . " WHERE AgricultureId=" . $obj_Agriculture->AgricultureId;
$rs = mysql_query($sql);
//if(mysql_affected_rows()> 0)
//{
$obj_retresult->type = 1;
$obj_retresult->data = $obj_Agriculture;
$obj_retresult->msg = "success";
//}
//else
//{
// $obj_retresult->type = 0;
// $obj_retresult->msg = "failed";
//}
} catch (Exception $ex) {
$obj_retresult->type = 0;
$obj_retresult->msg = "failed";
}
return $obj_retresult;
}
public static function update($obj_Person_workingexperiance)
{
$db = config::dbconfig();
$obj_retresult = new returnResult();
try {
$sql = "UPDATE tbl_person_workingexperiance SET " . "WorkExpId=" . common::noSqlInject($obj_Person_workingexperiance->WorkExpId) . "," . "CompanyId=" . common::noSqlInject($obj_Person_workingexperiance->CompanyId) . "," . "StartDate=" . "'" . common::noSqlInject($obj_Person_workingexperiance->StartDate) . "'" . "," . "EndDate=" . "'" . common::noSqlInject($obj_Person_workingexperiance->EndDate) . "'" . "," . "Position=" . "'" . common::noSqlInject($obj_Person_workingexperiance->Position) . "'" . "," . "PersonId=" . common::noSqlInject($obj_Person_workingexperiance->PersonId) . " WHERE WorkExpId=" . $obj_Person_workingexperiance->WorkExpId;
$rs = mysql_query($sql);
//if(mysql_affected_rows()> 0)
//{
$obj_retresult->type = 1;
$obj_retresult->data = $obj_Person_workingexperiance;
$obj_retresult->msg = "success";
//}
//else
//{
// $obj_retresult->type = 0;
// $obj_retresult->msg = "failed";
//}
} catch (Exception $ex) {
$obj_retresult->type = 0;
$obj_retresult->msg = "failed";
}
return $obj_retresult;
}
public static function update($obj_Village_organization)
{
$db = config::dbconfig();
$obj_retresult = new returnResult();
try {
$sql = "UPDATE tbl_village_organization SET " . "OrganizationId=" . common::noSqlInject($obj_Village_organization->OrganizationId) . "," . "VillageId=" . common::noSqlInject($obj_Village_organization->VillageId) . " WHERE VillageId=" . $obj_Village_organization->VillageId;
$rs = mysql_query($sql);
//if(mysql_affected_rows()> 0)
//{
$obj_retresult->type = 1;
$obj_retresult->data = $obj_Village_organization;
$obj_retresult->msg = "success";
//}
//else
//{
// $obj_retresult->type = 0;
// $obj_retresult->msg = "failed";
//}
} catch (Exception $ex) {
$obj_retresult->type = 0;
$obj_retresult->msg = "failed";
}
return $obj_retresult;
}
public static function update($obj_Group)
{
$db = config::dbconfig();
$obj_retresult = new returnResult();
try {
$sql = "UPDATE tbl_group SET " . "GroupId=" . common::noSqlInject($obj_Group->GroupId) . "," . "GroupName=" . "'" . common::noSqlInject($obj_Group->GroupName) . "'" . "," . "GroupPrimaryType=" . common::noSqlInject($obj_Group->GroupPrimaryType) . "," . "GroupMissionTypeId=" . common::noSqlInject($obj_Group->GroupMissionTypeId) . "," . "GroupAddress=" . "'" . common::noSqlInject($obj_Group->GroupAddress) . "'" . " WHERE GroupId=" . $obj_Group->GroupId;
$rs = mysql_query($sql);
//if(mysql_affected_rows()> 0)
//{
$obj_retresult->type = 1;
$obj_retresult->data = $obj_Group;
$obj_retresult->msg = "success";
//}
//else
//{
// $obj_retresult->type = 0;
// $obj_retresult->msg = "failed";
//}
} catch (Exception $ex) {
$obj_retresult->type = 0;
$obj_retresult->msg = "failed";
}
return $obj_retresult;
}
public static function update($obj_Group_member)
{
$db = config::dbconfig();
$obj_retresult = new returnResult();
try {
$sql = "UPDATE tbl_group_member SET " . "GroupId=" . common::noSqlInject($obj_Group_member->GroupId) . "," . "MemberId=" . common::noSqlInject($obj_Group_member->MemberId) . "," . "MemberType=" . "'" . common::noSqlInject($obj_Group_member->MemberType) . "'" . "," . "MemberDate=" . "'" . common::noSqlInject($obj_Group_member->MemberDate) . "'" . "," . "Description=" . "'" . common::noSqlInject($obj_Group_member->Description) . "'" . " WHERE MemberId=" . $obj_Group_member->MemberId;
$rs = mysql_query($sql);
//if(mysql_affected_rows()> 0)
//{
$obj_retresult->type = 1;
$obj_retresult->data = $obj_Group_member;
$obj_retresult->msg = "success";
//}
//else
//{
// $obj_retresult->type = 0;
// $obj_retresult->msg = "failed";
//}
} catch (Exception $ex) {
$obj_retresult->type = 0;
$obj_retresult->msg = "failed";
}
return $obj_retresult;
}
public static function update($obj_Society)
{
$db = config::dbconfig();
$obj_retresult = new returnResult();
try {
$sql = "UPDATE tbl_Society SET " . "SocietyId=" . common::noSqlInject($obj_Society->SocietyId) . "," . "Name=" . "'" . common::noSqlInject($obj_Society->Name) . "'" . "," . "Description=" . "'" . common::noSqlInject($obj_Society->Description) . "'" . "," . "Mission=" . "'" . common::noSqlInject($obj_Society->Mission) . "'" . "," . "SocietyTypeId=" . common::noSqlInject($obj_Society->SocietyTypeId) . "," . "SocietyAddress=" . "'" . common::noSqlInject($obj_Society->SocietyAddress) . "'" . " WHERE SocietyId=" . $obj_Society->SocietyId;
$rs = mysql_query($sql);
//if(mysql_affected_rows()> 0)
//{
$obj_retresult->type = 1;
$obj_retresult->data = $obj_Society;
$obj_retresult->msg = "success";
//}
//else
//{
// $obj_retresult->type = 0;
// $obj_retresult->msg = "failed";
//}
} catch (Exception $ex) {
$obj_retresult->type = 0;
$obj_retresult->msg = "failed";
}
return $obj_retresult;
}
public static function update($obj_User)
{
$db = config::dbconfig();
$obj_retresult = new returnResult();
try {
$sql = "UPDATE tbl_user SET " . "userId=" . common::noSqlInject($obj_User->userId) . "," . "userName="******"'" . common::noSqlInject($obj_User->userName) . "'" . "," . "password="******"'" . common::noSqlInject($obj_User->password) . "'" . "," . "personId=" . common::noSqlInject($obj_User->personId) . "," . "userType=" . common::noSqlInject($obj_User->userType) . "," . "userOptCode=" . "'" . common::noSqlInject($obj_User->userOptCode) . "'" . "," . "userMetadata=" . "'" . common::noSqlInject($obj_User->userMetadata) . "'" . "," . "userStatus=" . common::noSqlInject($obj_User->userStatus) . " WHERE userId=" . $obj_User->userId;
$rs = mysql_query($sql);
//if(mysql_affected_rows()> 0)
//{
$obj_retresult->type = 1;
$obj_retresult->data = $obj_User;
$obj_retresult->msg = "success";
//}
//else
//{
// $obj_retresult->type = 0;
// $obj_retresult->msg = "failed";
//}
} catch (Exception $ex) {
$obj_retresult->type = 0;
$obj_retresult->msg = "failed";
}
return $obj_retresult;
}
public static function update($obj_Person_property)
{
$db = config::dbconfig();
$obj_retresult = new returnResult();
try {
$sql = "UPDATE tbl_person_property SET " . "PropertyId=" . common::noSqlInject($obj_Person_property->PropertyId) . "," . "PropertyName=" . "'" . common::noSqlInject($obj_Person_property->PropertyName) . "'" . "," . "PropertyType=" . common::noSqlInject($obj_Person_property->PropertyType) . "," . "AssessValue=" . common::noSqlInject($obj_Person_property->AssessValue) . "," . "Description=" . "'" . common::noSqlInject($obj_Person_property->Description) . "'" . " WHERE PropertyId=" . $obj_Person_property->PropertyId;
$rs = mysql_query($sql);
//if(mysql_affected_rows()> 0)
//{
$obj_retresult->type = 1;
$obj_retresult->data = $obj_Person_property;
$obj_retresult->msg = "success";
//}
//else
//{
// $obj_retresult->type = 0;
// $obj_retresult->msg = "failed";
//}
} catch (Exception $ex) {
$obj_retresult->type = 0;
$obj_retresult->msg = "failed";
}
return $obj_retresult;
}
public static function update($obj_Errorlog)
{
$db = config::dbconfig();
$obj_retresult = new returnResult();
try {
$sql = "UPDATE tbl_Errorlog SET " . "_id=" . common::noSqlInject($obj_Errorlog->_id) . "," . "LoggedTime=" . "'" . common::noSqlInject($obj_Errorlog->LoggedTime) . "'" . "," . "Tag=" . "'" . common::noSqlInject($obj_Errorlog->Tag) . "'" . "," . "Place=" . "'" . common::noSqlInject($obj_Errorlog->Place) . "'" . "," . "Event=" . "'" . common::noSqlInject($obj_Errorlog->Event) . "'" . "," . "Message=" . "'" . common::noSqlInject($obj_Errorlog->Message) . "'" . "," . "metadata=" . "'" . common::noSqlInject($obj_Errorlog->metadata) . "'" . "," . "Status=" . common::noSqlInject($obj_Errorlog->Status) . " WHERE _id=" . $obj_Errorlog->_id;
$rs = mysql_query($sql);
//if(mysql_affected_rows()> 0)
//{
$obj_retresult->type = 1;
$obj_retresult->data = $obj_Errorlog;
$obj_retresult->msg = "success";
//}
//else
//{
// $obj_retresult->type = 0;
// $obj_retresult->msg = "failed";
//}
} catch (Exception $ex) {
$obj_retresult->type = 0;
$obj_retresult->msg = "failed";
}
return $obj_retresult;
}
public static function update($obj_Village_climate)
{
$db = config::dbconfig();
$obj_retresult = new returnResult();
try {
$sql = "UPDATE tbl_village_climate SET " . "ClimateId=" . common::noSqlInject($obj_Village_climate->ClimateId) . "," . "VillageId=" . common::noSqlInject($obj_Village_climate->VillageId) . "," . "ClimateReagion=" . "'" . common::noSqlInject($obj_Village_climate->ClimateReagion) . "'" . "," . "RainFall=" . common::noSqlInject($obj_Village_climate->RainFall) . "," . "Temparature=" . common::noSqlInject($obj_Village_climate->Temparature) . "," . "Humidity=" . common::noSqlInject($obj_Village_climate->Humidity) . " WHERE ClimateId=" . $obj_Village_climate->ClimateId;
$rs = mysql_query($sql);
//if(mysql_affected_rows()> 0)
//{
$obj_retresult->type = 1;
$obj_retresult->data = $obj_Village_climate;
$obj_retresult->msg = "success";
//}
//else
//{
// $obj_retresult->type = 0;
// $obj_retresult->msg = "failed";
//}
} catch (Exception $ex) {
$obj_retresult->type = 0;
$obj_retresult->msg = "failed";
}
return $obj_retresult;
}
public static function update($obj_Business_product)
{
$db = config::dbconfig();
$obj_retresult = new returnResult();
try {
$sql = "UPDATE tbl_business_product SET " . "BusinessId=" . common::noSqlInject($obj_Business_product->BusinessId) . "," . "ProductId=" . common::noSqlInject($obj_Business_product->ProductId) . " WHERE ProductId=" . $obj_Business_product->ProductId;
$rs = mysql_query($sql);
//if(mysql_affected_rows()> 0)
//{
$obj_retresult->type = 1;
$obj_retresult->data = $obj_Business_product;
$obj_retresult->msg = "success";
//}
//else
//{
// $obj_retresult->type = 0;
// $obj_retresult->msg = "failed";
//}
} catch (Exception $ex) {
$obj_retresult->type = 0;
$obj_retresult->msg = "failed";
}
return $obj_retresult;
}
public static function update($obj_Person)
{
$db = config::dbconfig();
$obj_retresult = new returnResult();
try {
$sql = "UPDATE tbl_person SET " . "PersonId=" . common::noSqlInject($obj_Person->PersonId) . "," . "FullName=" . "'" . common::noSqlInject($obj_Person->FullName) . "'" . "," . "NickName=" . "'" . common::noSqlInject($obj_Person->NickName) . "'" . "," . "OtherNames=" . "'" . common::noSqlInject($obj_Person->OtherNames) . "'" . "," . "DrivingLicenceNo=" . "'" . common::noSqlInject($obj_Person->DrivingLicenceNo) . "'" . "," . "PassportNo=" . "'" . common::noSqlInject($obj_Person->PassportNo) . "'" . "," . "PermanentAddress=" . "'" . common::noSqlInject($obj_Person->PermanentAddress) . "'" . "," . "Email=" . "'" . common::noSqlInject($obj_Person->Email) . "'" . "," . "Website=" . "'" . common::noSqlInject($obj_Person->Website) . "'" . "," . "Description=" . "'" . common::noSqlInject($obj_Person->Description) . "'" . "," . "Gender=" . common::noSqlInject($obj_Person->Gender) . "," . "DOB=" . "'" . common::noSqlInject($obj_Person->DOB) . "'" . "," . "Height=" . common::noSqlInject($obj_Person->Height) . "," . "Weight=" . common::noSqlInject($obj_Person->Weight) . "," . "HairColor=" . "'" . common::noSqlInject($obj_Person->HairColor) . "'" . "," . "EyeColor=" . "'" . common::noSqlInject($obj_Person->EyeColor) . "'" . "," . "BloodType=" . "'" . common::noSqlInject($obj_Person->BloodType) . "'" . "," . "Occupation=" . "'" . common::noSqlInject($obj_Person->Occupation) . "'" . "," . "MonthlyIncome=" . common::noSqlInject($obj_Person->MonthlyIncome) . "," . "FutureTargets=" . "'" . common::noSqlInject($obj_Person->FutureTargets) . "'" . "," . "FutureNeeds=" . "'" . common::noSqlInject($obj_Person->FutureNeeds) . "'" . "," . "DOD=" . "'" . common::noSqlInject($obj_Person->DOD) . "'" . "," . "Picture=" . "'" . common::noSqlInject($obj_Person->Picture) . "'" . "," . "NIC=" . "'" . common::noSqlInject($obj_Person->NIC) . "'" . "," . "Status=" . common::noSqlInject($obj_Person->Status) . " WHERE PersonId=" . $obj_Person->PersonId;
$rs = mysql_query($sql);
//if(mysql_affected_rows()> 0)
//{
$obj_retresult->type = 1;
$obj_retresult->data = $obj_Person;
$obj_retresult->msg = "success";
//}
//else
//{
// $obj_retresult->type = 0;
// $obj_retresult->msg = "failed";
//}
} catch (Exception $ex) {
$obj_retresult->type = 0;
$obj_retresult->msg = "failed";
}
return $obj_retresult;
}
public static function update($obj_Application_forms)
{
$db = config::dbconfig();
$obj_retresult = new returnResult();
try {
$sql = "UPDATE tbl_Application_forms SET " . "_id=" . common::noSqlInject($obj_Application_forms->_id) . "," . "ref_no=" . common::noSqlInject($obj_Application_forms->ref_no) . "," . "mobile_no=" . "'" . common::noSqlInject($obj_Application_forms->mobile_no) . "'" . "," . "mic_no=" . common::noSqlInject($obj_Application_forms->mic_no) . "," . "cus_title=" . "'" . common::noSqlInject($obj_Application_forms->cus_title) . "'" . "," . "nic_code=" . "'" . common::noSqlInject($obj_Application_forms->nic_code) . "'" . "," . "nic_no=" . "'" . common::noSqlInject($obj_Application_forms->nic_no) . "'" . "," . "cus_name=" . "'" . common::noSqlInject($obj_Application_forms->cus_name) . "'" . "," . "cus_name_other=" . "'" . common::noSqlInject($obj_Application_forms->cus_name_other) . "'" . "," . "cus_country=" . "'" . common::noSqlInject($obj_Application_forms->cus_country) . "'" . "," . "cus_company=" . "'" . common::noSqlInject($obj_Application_forms->cus_company) . "'" . "," . "cus_address1=" . "'" . common::noSqlInject($obj_Application_forms->cus_address1) . "'" . "," . "cus_address2=" . "'" . common::noSqlInject($obj_Application_forms->cus_address2) . "'" . "," . "district=" . "'" . common::noSqlInject($obj_Application_forms->district) . "'" . "," . "cus_telephone=" . common::noSqlInject($obj_Application_forms->cus_telephone) . "," . "cus_occupation=" . "'" . common::noSqlInject($obj_Application_forms->cus_occupation) . "'" . "," . "other=" . "'" . common::noSqlInject($obj_Application_forms->other) . "'" . "," . "amount_spend=" . common::noSqlInject($obj_Application_forms->amount_spend) . "," . "no_of_family1=" . common::noSqlInject($obj_Application_forms->no_of_family1) . "," . "no_of_family2=" . common::noSqlInject($obj_Application_forms->no_of_family2) . "," . "cus_language=" . common::noSqlInject($obj_Application_forms->cus_language) . "," . "cus_email=" . "'" . common::noSqlInject($obj_Application_forms->cus_email) . "'" . "," . "sim_no=" . "'" . common::noSqlInject($obj_Application_forms->sim_no) . "'" . "," . "added_date=" . "'" . common::noSqlInject($obj_Application_forms->added_date) . "'" . "," . "img_name=" . "'" . common::noSqlInject($obj_Application_forms->img_name) . "'" . "," . "doc_path=" . "'" . common::noSqlInject($obj_Application_forms->doc_path) . "'" . "," . "folder_path=" . "'" . common::noSqlInject($obj_Application_forms->folder_path) . "'" . "," . "job_id=" . common::noSqlInject($obj_Application_forms->job_id) . "," . "meta=" . "'" . common::noSqlInject($obj_Application_forms->meta) . "'" . "," . "status=" . common::noSqlInject($obj_Application_forms->status) . " WHERE _id=" . $obj_Application_forms->_id;
$rs = mysql_query($sql);
//if(mysql_affected_rows()> 0)
//{
$obj_retresult->type = 1;
$obj_retresult->data = $obj_Application_forms;
$obj_retresult->msg = "success";
//}
//else
//{
// $obj_retresult->type = 0;
// $obj_retresult->msg = "failed";
//}
} catch (Exception $ex) {
$obj_retresult->type = 0;
$obj_retresult->msg = "failed";
}
return $obj_retresult;
}
public static function update($obj_Job_meta)
{
$db = config::dbconfig();
$obj_retresult = new returnResult();
try {
$sql = "UPDATE tbl_Job_meta SET " . "_id=" . common::noSqlInject($obj_Job_meta->_id) . "," . "LoggedTime=" . "'" . common::noSqlInject($obj_Job_meta->LoggedTime) . "'" . "," . "JobID=" . "'" . common::noSqlInject($obj_Job_meta->JobID) . "'" . "," . "JobType=" . "'" . common::noSqlInject($obj_Job_meta->JobType) . "'" . "," . "JobData=" . "'" . common::noSqlInject($obj_Job_meta->JobData) . "'" . "," . "Status=" . common::noSqlInject($obj_Job_meta->Status) . "," . "client_name=" . "'" . common::noSqlInject($obj_Job_meta->client_name) . "'" . "," . "client_mobile=" . "'" . common::noSqlInject($obj_Job_meta->client_mobile) . "'" . "," . "client_simid=" . "'" . common::noSqlInject($obj_Job_meta->client_simid) . "'" . "," . "client_nic=" . "'" . common::noSqlInject($obj_Job_meta->client_nic) . "'" . " WHERE _id=" . $obj_Job_meta->_id;
$rs = mysql_query($sql);
//if(mysql_affected_rows()> 0)
//{
$obj_retresult->type = 1;
$obj_retresult->data = $obj_Job_meta;
$obj_retresult->msg = "success";
//}
//else
//{
// $obj_retresult->type = 0;
// $obj_retresult->msg = "failed";
//}
} catch (Exception $ex) {
$obj_retresult->type = 0;
$obj_retresult->msg = "failed";
}
return $obj_retresult;
}
public static function update($obj_Business)
{
$db = config::dbconfig();
$obj_retresult = new returnResult();
try {
$sql = "UPDATE tbl_business SET " . "BusinessId=" . common::noSqlInject($obj_Business->BusinessId) . "," . "Name=" . "'" . common::noSqlInject($obj_Business->Name) . "'" . "," . "Description=" . "'" . common::noSqlInject($obj_Business->Description) . "'" . "," . "Address=" . "'" . common::noSqlInject($obj_Business->Address) . "'" . "," . "telephone=" . "'" . common::noSqlInject($obj_Business->telephone) . "'" . "," . "fax=" . "'" . common::noSqlInject($obj_Business->fax) . "'" . "," . "website=" . "'" . common::noSqlInject($obj_Business->website) . "'" . "," . "email=" . "'" . common::noSqlInject($obj_Business->email) . "'" . "," . "BusinessTypeId=" . common::noSqlInject($obj_Business->BusinessTypeId) . "," . "BusinessSubTypeId=" . common::noSqlInject($obj_Business->BusinessSubTypeId) . " WHERE BusinessId=" . $obj_Business->BusinessId;
$rs = mysql_query($sql);
//if(mysql_affected_rows()> 0)
//{
$obj_retresult->type = 1;
$obj_retresult->data = $obj_Business;
$obj_retresult->msg = "success";
//}
//else
//{
// $obj_retresult->type = 0;
// $obj_retresult->msg = "failed";
//}
} catch (Exception $ex) {
$obj_retresult->type = 0;
$obj_retresult->msg = "failed";
}
return $obj_retresult;
}
public static function update($obj_File_repository)
{
$db = config::dbconfig();
$obj_retresult = new returnResult();
try {
$sql = "UPDATE tbl_File_repository SET " . "_id=" . common::noSqlInject($obj_File_repository->_id) . "," . "LoggedTime=" . "'" . common::noSqlInject($obj_File_repository->LoggedTime) . "'" . "," . "FileName=" . "'" . common::noSqlInject($obj_File_repository->FileName) . "'" . "," . "FilePath=" . "'" . common::noSqlInject($obj_File_repository->FilePath) . "'" . "," . "AgentID=" . "'" . common::noSqlInject($obj_File_repository->AgentID) . "'" . "," . "JobID=" . "'" . common::noSqlInject($obj_File_repository->JobID) . "'" . "," . "Extension=" . "'" . common::noSqlInject($obj_File_repository->Extension) . "'" . "," . "metadata=" . "'" . common::noSqlInject($obj_File_repository->metadata) . "'" . "," . "Status=" . common::noSqlInject($obj_File_repository->Status) . " WHERE _id=" . $obj_File_repository->_id;
$rs = mysql_query($sql);
//if(mysql_affected_rows()> 0)
//{
$obj_retresult->type = 1;
$obj_retresult->data = $obj_File_repository;
$obj_retresult->msg = "success";
//}
//else
//{
// $obj_retresult->type = 0;
// $obj_retresult->msg = "failed";
//}
} catch (Exception $ex) {
$obj_retresult->type = 0;
$obj_retresult->msg = "failed";
}
return $obj_retresult;
}
public static function update($obj_Village)
{
$db = config::dbconfig();
$obj_retresult = new returnResult();
try {
$sql = "UPDATE tbl_village SET " . "VillageId=" . common::noSqlInject($obj_Village->VillageId) . "," . "Name=" . "'" . common::noSqlInject($obj_Village->Name) . "'" . "," . "VillageNumber=" . common::noSqlInject($obj_Village->VillageNumber) . "," . "AgaDevision=" . "'" . common::noSqlInject($obj_Village->AgaDevision) . "'" . "," . "District=" . "'" . common::noSqlInject($obj_Village->District) . "'" . "," . "Province=" . "'" . common::noSqlInject($obj_Village->Province) . "'" . "," . "GeogrophyTypeId=" . common::noSqlInject($obj_Village->GeogrophyTypeId) . "," . "ForestTypeId=" . common::noSqlInject($obj_Village->ForestTypeId) . "," . "ForestDescription=" . "'" . common::noSqlInject($obj_Village->ForestDescription) . "'" . "," . "TraditionalKnowledge=" . "'" . common::noSqlInject($obj_Village->TraditionalKnowledge) . "'" . " WHERE VillageId=" . $obj_Village->VillageId;
$rs = mysql_query($sql);
//if(mysql_affected_rows()> 0)
//{
$obj_retresult->type = 1;
$obj_retresult->data = $obj_Village;
$obj_retresult->msg = "success";
//}
//else
//{
// $obj_retresult->type = 0;
// $obj_retresult->msg = "failed";
//}
} catch (Exception $ex) {
$obj_retresult->type = 0;
$obj_retresult->msg = "failed";
}
return $obj_retresult;
}
public static function update($obj_Person_vocationaltraining)
{
$db = config::dbconfig();
$obj_retresult = new returnResult();
try {
$sql = "UPDATE tbl_person_vocationaltraining SET " . "VocationalTrainId=" . common::noSqlInject($obj_Person_vocationaltraining->VocationalTrainId) . "," . "FieldName=" . "'" . common::noSqlInject($obj_Person_vocationaltraining->FieldName) . "'" . "," . "CourseName=" . "'" . common::noSqlInject($obj_Person_vocationaltraining->CourseName) . "'" . "," . "InstituteId=" . common::noSqlInject($obj_Person_vocationaltraining->InstituteId) . "," . "StartDate=" . "'" . common::noSqlInject($obj_Person_vocationaltraining->StartDate) . "'" . "," . "EndDate=" . "'" . common::noSqlInject($obj_Person_vocationaltraining->EndDate) . "'" . "," . "CertificateType=" . "'" . common::noSqlInject($obj_Person_vocationaltraining->CertificateType) . "'" . "," . "PersonId=" . common::noSqlInject($obj_Person_vocationaltraining->PersonId) . " WHERE VocationalTrainId=" . $obj_Person_vocationaltraining->VocationalTrainId;
$rs = mysql_query($sql);
//if(mysql_affected_rows()> 0)
//{
$obj_retresult->type = 1;
$obj_retresult->data = $obj_Person_vocationaltraining;
$obj_retresult->msg = "success";
//}
//else
//{
// $obj_retresult->type = 0;
// $obj_retresult->msg = "failed";
//}
} catch (Exception $ex) {
$obj_retresult->type = 0;
$obj_retresult->msg = "failed";
}
return $obj_retresult;
}
public static function update($obj_User_to_job)
{
$db = config::dbconfig();
$obj_retresult = new returnResult();
try {
$sql = "UPDATE tbl_user_to_job SET " . "_id=" . common::noSqlInject($obj_User_to_job->_id) . "," . "user_id=" . common::noSqlInject($obj_User_to_job->user_id) . "," . "job_id=" . common::noSqlInject($obj_User_to_job->job_id) . "," . "meta=" . "'" . common::noSqlInject($obj_User_to_job->meta) . "'" . "," . "Status=" . common::noSqlInject($obj_User_to_job->Status) . " WHERE _id=" . $obj_User_to_job->_id;
$rs = mysql_query($sql);
//if(mysql_affected_rows()> 0)
//{
$obj_retresult->type = 1;
$obj_retresult->data = $obj_User_to_job;
$obj_retresult->msg = "success";
//}
//else
//{
// $obj_retresult->type = 0;
// $obj_retresult->msg = "failed";
//}
} catch (Exception $ex) {
$obj_retresult->type = 0;
$obj_retresult->msg = "failed";
}
return $obj_retresult;
}
public static function update($obj_Person_talent)
{
$db = config::dbconfig();
$obj_retresult = new returnResult();
try {
$sql = "UPDATE tbl_person_talent SET " . "TblId=" . common::noSqlInject($obj_Person_talent->TblId) . "," . "PersonId=" . common::noSqlInject($obj_Person_talent->PersonId) . "," . "TalentId=" . common::noSqlInject($obj_Person_talent->TalentId) . " WHERE TblId=" . $obj_Person_talent->TblId;
$rs = mysql_query($sql);
//if(mysql_affected_rows()> 0)
//{
$obj_retresult->type = 1;
$obj_retresult->data = $obj_Person_talent;
$obj_retresult->msg = "success";
//}
//else
//{
// $obj_retresult->type = 0;
// $obj_retresult->msg = "failed";
//}
} catch (Exception $ex) {
$obj_retresult->type = 0;
$obj_retresult->msg = "failed";
}
return $obj_retresult;
}
public static function update($obj_Village_geologicalvariation)
{
$db = config::dbconfig();
$obj_retresult = new returnResult();
try {
$sql = "UPDATE tbl_village_geologicalvariation SET " . "TblId=" . common::noSqlInject($obj_Village_geologicalvariation->TblId) . "," . "VillageId=" . common::noSqlInject($obj_Village_geologicalvariation->VillageId) . "," . "Variation=" . "'" . common::noSqlInject($obj_Village_geologicalvariation->Variation) . "'" . "," . "Description=" . "'" . common::noSqlInject($obj_Village_geologicalvariation->Description) . "'" . "," . "PrimaryGeoLayerTypeId=" . common::noSqlInject($obj_Village_geologicalvariation->PrimaryGeoLayerTypeId) . "," . "SoilTypeId=" . common::noSqlInject($obj_Village_geologicalvariation->SoilTypeId) . " WHERE TblId=" . $obj_Village_geologicalvariation->TblId;
$rs = mysql_query($sql);
//if(mysql_affected_rows()> 0)
//{
$obj_retresult->type = 1;
$obj_retresult->data = $obj_Village_geologicalvariation;
$obj_retresult->msg = "success";
//}
//else
//{
// $obj_retresult->type = 0;
// $obj_retresult->msg = "failed";
//}
} catch (Exception $ex) {
$obj_retresult->type = 0;
$obj_retresult->msg = "failed";
}
return $obj_retresult;
}
public static function update($obj_Location_resources)
{
$db = config::dbconfig();
$obj_retresult = new returnResult();
try {
$sql = "UPDATE tbl_Location_resources SET " . "ResourceId=" . common::noSqlInject($obj_Location_resources->ResourceId) . "," . "LocationId=" . common::noSqlInject($obj_Location_resources->LocationId) . "," . "ResourceType=" . common::noSqlInject($obj_Location_resources->ResourceType) . "," . "ResourcePath=" . "'" . common::noSqlInject($obj_Location_resources->ResourcePath) . "'" . " WHERE ResourceId=" . $obj_Location_resources->ResourceId;
$rs = mysql_query($sql);
//if(mysql_affected_rows()> 0)
//{
$obj_retresult->type = 1;
$obj_retresult->data = $obj_Location_resources;
$obj_retresult->msg = "success";
//}
//else
//{
// $obj_retresult->type = 0;
// $obj_retresult->msg = "failed";
//}
} catch (Exception $ex) {
$obj_retresult->type = 0;
$obj_retresult->msg = "failed";
}
return $obj_retresult;
}
public static function update($obj_Olsubjects)
{
$db = config::dbconfig();
$obj_retresult = new returnResult();
try {
$sql = "UPDATE tbl_Olsubjects SET " . "SubjectId=" . common::noSqlInject($obj_Olsubjects->SubjectId) . "," . "SubjectName=" . "'" . common::noSqlInject($obj_Olsubjects->SubjectName) . "'" . "," . "SubjectNumber=" . common::noSqlInject($obj_Olsubjects->SubjectNumber) . " WHERE SubjectId=" . $obj_Olsubjects->SubjectId;
$rs = mysql_query($sql);
//if(mysql_affected_rows()> 0)
//{
$obj_retresult->type = 1;
$obj_retresult->data = $obj_Olsubjects;
$obj_retresult->msg = "success";
//}
//else
//{
// $obj_retresult->type = 0;
// $obj_retresult->msg = "failed";
//}
} catch (Exception $ex) {
$obj_retresult->type = 0;
$obj_retresult->msg = "failed";
}
return $obj_retresult;
}
public static function update($obj_Village_trading)
{
$db = config::dbconfig();
$obj_retresult = new returnResult();
try {
$sql = "UPDATE tbl_village_trading SET " . "TradingId=" . common::noSqlInject($obj_Village_trading->TradingId) . "," . "VillageId=" . common::noSqlInject($obj_Village_trading->VillageId) . "," . "BusinessId=" . common::noSqlInject($obj_Village_trading->BusinessId) . "," . "Description=" . "'" . common::noSqlInject($obj_Village_trading->Description) . "'" . " WHERE BusinessId=" . $obj_Village_trading->BusinessId;
$rs = mysql_query($sql);
//if(mysql_affected_rows()> 0)
//{
$obj_retresult->type = 1;
$obj_retresult->data = $obj_Village_trading;
$obj_retresult->msg = "success";
//}
//else
//{
// $obj_retresult->type = 0;
// $obj_retresult->msg = "failed";
//}
} catch (Exception $ex) {
$obj_retresult->type = 0;
$obj_retresult->msg = "failed";
}
return $obj_retresult;
}
public static function update($obj_Agent)
{
$db = config::dbconfig();
$obj_retresult = new returnResult();
try {
$sql = "UPDATE tbl_Agent SET " . "_id=" . common::noSqlInject($obj_Agent->_id) . "," . "agent_code=" . "'" . common::noSqlInject($obj_Agent->agent_code) . "'" . "," . "agent_name=" . "'" . common::noSqlInject($obj_Agent->agent_name) . "'" . "," . "agent_pass="******"'" . common::noSqlInject($obj_Agent->agent_pass) . "'" . "," . "agent_type=" . common::noSqlInject($obj_Agent->agent_type) . "," . "reg_date=" . "'" . common::noSqlInject($obj_Agent->reg_date) . "'" . "," . "meta=" . "'" . common::noSqlInject($obj_Agent->meta) . "'" . "," . "Status=" . common::noSqlInject($obj_Agent->Status) . " WHERE _id=" . $obj_Agent->_id;
$rs = mysql_query($sql);
//if(mysql_affected_rows()> 0)
//{
$obj_retresult->type = 1;
$obj_retresult->data = $obj_Agent;
$obj_retresult->msg = "success";
//}
//else
//{
// $obj_retresult->type = 0;
// $obj_retresult->msg = "failed";
//}
} catch (Exception $ex) {
$obj_retresult->type = 0;
$obj_retresult->msg = "failed";
}
return $obj_retresult;
}
public static function update($obj_Person_address)
{
$db = config::dbconfig();
$obj_retresult = new returnResult();
try {
$sql = "UPDATE tbl_person_address SET " . "AddressId=" . common::noSqlInject($obj_Person_address->AddressId) . "," . "Address=" . "'" . common::noSqlInject($obj_Person_address->Address) . "'" . "," . "AddressType=" . common::noSqlInject($obj_Person_address->AddressType) . "," . "VillageId=" . common::noSqlInject($obj_Person_address->VillageId) . "," . "PersonId=" . common::noSqlInject($obj_Person_address->PersonId) . " WHERE AddressId=" . $obj_Person_address->AddressId;
$rs = mysql_query($sql);
//if(mysql_affected_rows()> 0)
//{
$obj_retresult->type = 1;
$obj_retresult->data = $obj_Person_address;
$obj_retresult->msg = "success";
//}
//else
//{
// $obj_retresult->type = 0;
// $obj_retresult->msg = "failed";
//}
} catch (Exception $ex) {
$obj_retresult->type = 0;
$obj_retresult->msg = "failed";
}
return $obj_retresult;
}
public static function update($obj_Person_educationlevel)
{
$db = config::dbconfig();
$obj_retresult = new returnResult();
try {
$sql = "UPDATE tbl_person_educationlevel SET " . "EducationLevelId=" . common::noSqlInject($obj_Person_educationlevel->EducationLevelId) . "," . "SchoolId=" . common::noSqlInject($obj_Person_educationlevel->SchoolId) . "," . "StartYear=" . "'" . common::noSqlInject($obj_Person_educationlevel->StartYear) . "'" . "," . "StartClass=" . "'" . common::noSqlInject($obj_Person_educationlevel->StartClass) . "'" . "," . "EndYear=" . "'" . common::noSqlInject($obj_Person_educationlevel->EndYear) . "'" . "," . "EndClass=" . "'" . common::noSqlInject($obj_Person_educationlevel->EndClass) . "'" . "," . "PersonId=" . common::noSqlInject($obj_Person_educationlevel->PersonId) . " WHERE EducationLevelId=" . $obj_Person_educationlevel->EducationLevelId;
$rs = mysql_query($sql);
//if(mysql_affected_rows()> 0)
//{
$obj_retresult->type = 1;
$obj_retresult->data = $obj_Person_educationlevel;
$obj_retresult->msg = "success";
//}
//else
//{
// $obj_retresult->type = 0;
// $obj_retresult->msg = "failed";
//}
} catch (Exception $ex) {
$obj_retresult->type = 0;
$obj_retresult->msg = "failed";
}
return $obj_retresult;
}
public static function update($obj_Person_languageskill)
{
$db = config::dbconfig();
$obj_retresult = new returnResult();
try {
$sql = "UPDATE tbl_person_languageskill SET " . "LangSkillId=" . common::noSqlInject($obj_Person_languageskill->LangSkillId) . "," . "PersonId=" . common::noSqlInject($obj_Person_languageskill->PersonId) . "," . "Language=" . "'" . common::noSqlInject($obj_Person_languageskill->Language) . "'" . "," . "SkillType=" . "'" . common::noSqlInject($obj_Person_languageskill->SkillType) . "'" . "," . "Grade=" . "'" . common::noSqlInject($obj_Person_languageskill->Grade) . "'" . " WHERE LangSkillId=" . $obj_Person_languageskill->LangSkillId;
$rs = mysql_query($sql);
//if(mysql_affected_rows()> 0)
//{
$obj_retresult->type = 1;
$obj_retresult->data = $obj_Person_languageskill;
$obj_retresult->msg = "success";
//}
//else
//{
// $obj_retresult->type = 0;
// $obj_retresult->msg = "failed";
//}
} catch (Exception $ex) {
$obj_retresult->type = 0;
$obj_retresult->msg = "failed";
}
return $obj_retresult;
}
public static function update($obj_Language)
{
$db = config::dbconfig();
$obj_retresult = new returnResult();
try {
$sql = "UPDATE tbl_Language SET " . "LangId=" . common::noSqlInject($obj_Language->LangId) . "," . "LangTag=" . "'" . common::noSqlInject($obj_Language->LangTag) . "'" . "," . "English=" . "'" . common::noSqlInject($obj_Language->English) . "'" . "," . "Sinhala=" . "'" . common::noSqlInject($obj_Language->Sinhala) . "'" . "," . "Tamil=" . "'" . common::noSqlInject($obj_Language->Tamil) . "'" . "," . "Bangla=" . "'" . common::noSqlInject($obj_Language->Bangla) . "'" . "," . "Nepali=" . "'" . common::noSqlInject($obj_Language->Nepali) . "'" . "," . "Lang1=" . "'" . common::noSqlInject($obj_Language->Lang1) . "'" . "," . "Lang2=" . "'" . common::noSqlInject($obj_Language->Lang2) . "'" . "," . "Lang3=" . "'" . common::noSqlInject($obj_Language->Lang3) . "'" . " WHERE LangId=" . $obj_Language->LangId;
$rs = mysql_query($sql);
//if(mysql_affected_rows()> 0)
//{
$obj_retresult->type = 1;
$obj_retresult->data = $obj_Language;
$obj_retresult->msg = "success";
//}
//else
//{
// $obj_retresult->type = 0;
// $obj_retresult->msg = "failed";
//}
} catch (Exception $ex) {
$obj_retresult->type = 0;
$obj_retresult->msg = "failed";
}
return $obj_retresult;
}
