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();
}
}
