public int PostUpDateAhwalMapping([FromBody] ahwalmapping frm) { int ret = 0; NpgsqlConnection cont = new NpgsqlConnection(); cont.ConnectionString = constr; cont.Open(); NpgsqlCommand cmd = new NpgsqlCommand(); cmd.Connection = cont; cmd.CommandText = "update ahwalmapping set ahwalid = " + frm.ahwalid + ",sectorid=" + frm.sectorid + ",citygroupid=" + frm.citygroupid + ",shiftid=" + frm.shiftid + ",patrolroleid=" + frm.patrolroleid + ",personid=" + frm.personid + " where ahwalmappingid = " + frm.ahwalmappingid; ret = cmd.ExecuteNonQuery(); cont.Close(); cont.Dispose(); return(ret); }
public int PostAddAhwalMapping([FromBody] ahwalmapping frm) { int ret = 0; NpgsqlConnection cont = new NpgsqlConnection(); cont.ConnectionString = constr; cont.Open(); NpgsqlCommand cmd = new NpgsqlCommand(); cmd.Connection = cont; cmd.CommandText = "insert into ahwalmapping(ahwalid,sectorid,citygroupid,shiftid,patrolroleid,personid) values (" + frm.ahwalid + "," + frm.sectorid + "," + frm.citygroupid + "," + frm.shiftid + "," + frm.patrolroleid + "," + frm.personid + ")"; ret = cmd.ExecuteNonQuery(); cont.Close(); cont.Dispose(); return(ret); }