public bool UpdateSERVICES(SERVICES sERVICES)
{
using (SqlConnection connection = new SqlConnection(this.ConnectionString))
{
SqlCommand cmd = new SqlCommand("AbiMatuEnterprise_UpdateSERVICES", connection);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add("@SERVICESID", SqlDbType.Int).Value = sERVICES.SERVICESID;
cmd.Parameters.Add("@SERVICETYPE", SqlDbType.VarChar).Value = sERVICES.SERVICETYPE;
cmd.Parameters.Add("@SERVICENAME", SqlDbType.VarChar).Value = sERVICES.SERVICENAME;
cmd.Parameters.Add("@SERVICEFEE", SqlDbType.Int).Value = sERVICES.SERVICEFEE;
cmd.Parameters.Add("@ISQUICKACCESS", SqlDbType.VarChar).Value = sERVICES.ISQUICKACCESS;
cmd.Parameters.Add("@ISTAXABLE", SqlDbType.VarChar).Value = sERVICES.ISTAXABLE;
cmd.Parameters.Add("@PAYMENTMODE", SqlDbType.VarChar).Value = sERVICES.PAYMENTMODE;
cmd.Parameters.Add("@ITEMINSTOCK", SqlDbType.Int).Value = sERVICES.ITEMINSTOCK;
cmd.Parameters.Add("@REORDERLEVEL", SqlDbType.Int).Value = sERVICES.REORDERLEVEL;
cmd.Parameters.Add("@COSTPRICE", SqlDbType.Int).Value = sERVICES.COSTPRICE;
cmd.Parameters.Add("@RETAILPRICE", SqlDbType.Int).Value = sERVICES.RETAILPRICE;
cmd.Parameters.Add("@CREATEDON", SqlDbType.DateTime).Value = sERVICES.CREATEDON;
cmd.Parameters.Add("@CREATEDBY", SqlDbType.VarChar).Value = sERVICES.CREATEDBY;
cmd.Parameters.Add("@UPDATEDON", SqlDbType.DateTime).Value = sERVICES.UPDATEDON;
cmd.Parameters.Add("@UPDATEDBY", SqlDbType.VarChar).Value = sERVICES.UPDATEDBY;
cmd.Parameters.Add("@COMM", SqlDbType.Int).Value = sERVICES.COMM;
cmd.Parameters.Add("@ISCOMMCOUNTED", SqlDbType.VarChar).Value = sERVICES.ISCOMMCOUNTED;
cmd.Parameters.Add("@SERVICECOMM", SqlDbType.Int).Value = sERVICES.SERVICECOMM;
cmd.Parameters.Add("@STORECOMM", SqlDbType.Int).Value = sERVICES.STORECOMM;
cmd.Parameters.Add("@QUICKBOOKSERVICENAME", SqlDbType.VarChar).Value = sERVICES.QUICKBOOKSERVICENAME;
cmd.Parameters.Add("@QUICKBOOKSERVICEACCOUNT", SqlDbType.VarChar).Value = sERVICES.QUICKBOOKSERVICEACCOUNT;
connection.Open();
int result = cmd.ExecuteNonQuery();
return(result == 1);
}
}
public SERVICES GetSERVICESFromReader(IDataReader reader)
{
try
{
SERVICES sERVICES = new SERVICES
(
(int)reader["SERVICESID"],
reader["SERVICETYPE"].ToString(),
reader["SERVICENAME"].ToString(),
(int)reader["SERVICEFEE"],
reader["ISQUICKACCESS"].ToString(),
reader["ISTAXABLE"].ToString(),
reader["PAYMENTMODE"].ToString(),
(int)reader["ITEMINSTOCK"],
(int)reader["REORDERLEVEL"],
(int)reader["COSTPRICE"],
(int)reader["RETAILPRICE"],
(DateTime)reader["CREATEDON"],
reader["CREATEDBY"].ToString(),
(DateTime)reader["UPDATEDON"],
reader["UPDATEDBY"].ToString(),
(int)reader["COMM"],
reader["ISCOMMCOUNTED"].ToString(),
(int)reader["SERVICECOMM"],
(int)reader["STORECOMM"],
reader["QUICKBOOKSERVICENAME"].ToString(),
reader["QUICKBOOKSERVICEACCOUNT"].ToString()
);
return(sERVICES);
}
catch (Exception ex)
{
return(null);
}
}
public static SERVICES GetSERVICESByID(int id)
{
SERVICES sERVICES = new SERVICES();
SqlSERVICESProvider sqlSERVICESProvider = new SqlSERVICESProvider();
sERVICES = sqlSERVICESProvider.GetSERVICESByID(id);
return(sERVICES);
}
protected override bool EqualsRDATA(RR rr)
{
return(ORDER.Equals(((NAPTR)rr).ORDER) &&
PREFERENCE.Equals(((NAPTR)rr).PREFERENCE) &&
FLAGS.Equals(((NAPTR)rr).FLAGS) &&
SERVICES.Equals(((NAPTR)rr).SERVICES) &&
REGEXP.Equals(((NAPTR)rr).REGEXP) &&
REPLACEMENT.Equals(((NAPTR)rr).REPLACEMENT));
}
public override string ToString(int namePadding)
{
return(String.Join(" ", new string[] {
Base.ToString(namePadding),
ORDER.ToString(),
PREFERENCE.ToString(),
String.Format("\"{0}\"", FLAGS),
SERVICES.ToQuotedString(),
REGEXP.ToQuotedString(),
REPLACEMENT.ToString()
}));
}
// PUT: api/Services/5
public void Put(int id, [FromBody] SERVICES service)
{
this.management.Editar(service);
}
// POST: api/Services
public void Post([FromBody] SERVICES service)
{
this.management.Agregar(service);
}
public static bool UpdateSERVICES(SERVICES sERVICES)
{
SqlSERVICESProvider sqlSERVICESProvider = new SqlSERVICESProvider();
return(sqlSERVICESProvider.UpdateSERVICES(sERVICES));
}
public static int InsertSERVICES(SERVICES sERVICES)
{
SqlSERVICESProvider sqlSERVICESProvider = new SqlSERVICESProvider();
return(sqlSERVICESProvider.InsertSERVICES(sERVICES));
}
