public void AddParameters(MisPrty misParty) { cmd.Parameters.Add("@CODE", SqlDbType.VarChar, 4).Value = misParty.CODE; cmd.Parameters.Add("@TYPE", SqlDbType.VarChar, 1).Value = misParty.TYPE; cmd.Parameters.Add("@NAME", SqlDbType.VarChar, 45).Value = misParty.NAME; cmd.Parameters.Add("@SHORT_NAME", SqlDbType.VarChar, 10).Value = misParty.SHORT_NAME; cmd.Parameters.Add("@ADD1", SqlDbType.VarChar, 45).Value = misParty.ADD1; cmd.Parameters.Add("@ADD2", SqlDbType.VarChar, 45).Value = misParty.ADD2; cmd.Parameters.Add("@ADD3", SqlDbType.VarChar, 45).Value = misParty.ADD3; cmd.Parameters.Add("@CONTPER", SqlDbType.VarChar, 45).Value = misParty.CONTPER; cmd.Parameters.Add("@EMAIL", SqlDbType.VarChar, 35).Value = misParty.EMAIL; cmd.Parameters.Add("@WEB_ADD", SqlDbType.VarChar, 45).Value = misParty.WEB_ADD; cmd.Parameters.Add("@MOBILE", SqlDbType.VarChar, 30).Value = misParty.MOBILE; cmd.Parameters.Add("@PHONE", SqlDbType.VarChar, 30).Value = misParty.PHONE; cmd.Parameters.Add("@FAX", SqlDbType.VarChar, 30).Value = misParty.FAX; if (misParty.RELA != null) { cmd.Parameters.Add("@RELA", SqlDbType.DateTime).Value = Convert.ToDateTime(misParty.RELA); } else { cmd.Parameters.Add("@RELA", SqlDbType.DateTime).Value = DBNull.Value; } cmd.Parameters.Add("@REMARKS", SqlDbType.VarChar).Value = misParty.REMARKS; cmd.Parameters.Add("@MISCTYPE", SqlDbType.VarChar, 1).Value = misParty.MISCTYPE; }
public HttpResponseMessage UpdateMiscParty(MisPrty misPrty) { try { int result = new MiscPartycls().UpdateMiscParty(misPrty); if (result == 1) { return(Request.CreateResponse(HttpStatusCode.OK, result)); } else { return(Request.CreateResponse(HttpStatusCode.NotModified)); } } catch (Exception Ex) { return(Request.CreateResponse(HttpStatusCode.BadRequest, Ex.Message)); } }
public HttpResponseMessage InsertMiscParty(MisPrty misPrty) { try { int result = new MiscPartycls().InsertMiscParty(misPrty); if (result == 1) { return(Request.CreateResponse(HttpStatusCode.OK)); } else { return(Request.CreateResponse(HttpStatusCode.NotAcceptable)); } } catch (Exception Ex) { return(Request.CreateResponse(HttpStatusCode.BadRequest, Ex.Message)); } }
//----Save MiscParty Party -------- public int InsertMiscParty(MisPrty misParty) { int result = 0; try { AddParameters(misParty); cmd.Parameters.AddWithValue("@Action ", "INSERT"); result = cmd.ExecuteNonQuery(); return(result); } catch (Exception ex) { System.Diagnostics.Debug.WriteLine(ex.Message); return(result); } finally { conn.Close(); } }
//---------Update Salesco-ordinator -------- public int UpdateSalesCoordinator(MisPrty misPrty) { int result = 0; try { AddParameters(misPrty); cmd.Parameters.AddWithValue("@Pid", misPrty.PID); cmd.Parameters.AddWithValue("@Action", "UPDATE"); result = cmd.ExecuteNonQuery(); return(result); } catch (Exception ex) { System.Diagnostics.Debug.WriteLine(ex.Message); return(result); } finally { conn.Close(); } }