public HttpResponseMessage GetRawExpensesFixedUsingId(HttpRequestMessage request, int Id)
{
return(GetHttpResponse(request, () =>
{
HttpResponseMessage res = null;
OpexMtd obj = new OpexMtd();
RawExpensesFixedModel opex = obj.GetRawExpensesFixedById(Id);
res = request.CreateResponse(HttpStatusCode.OK, opex);
return res;
}));
}
} //========== end of the mtd
public Models.RawExpensesFixedModel GetRawExpensesFixedById(int Id)
{
var op = new RawExpensesFixedModel();
using (var con = new System.Data.SqlClient.SqlConnection(connectionString))
{
var cmd = new System.Data.SqlClient.SqlCommand("spp_RawExpensesFixed_Id", con);
cmd.CommandType = System.Data.CommandType.StoredProcedure;
cmd.CommandTimeout = 0;
//cmd.Parameters.Add("@result", System.Data.SqlDbType.TinyInt).Direction = System.Data.ParameterDirection.Output;
cmd.Parameters.Add(new SqlParameter
{
ParameterName = "Id",
Value = Id,
});
con.Open();
//cmd.ExecuteNonQuery();
//cmd2.ExecuteNonQuery();
SqlDataReader reader = cmd.ExecuteReader();
while (reader.Read())
{
op.FINID = reader["FINID"] != DBNull.Value ? int.Parse(reader["FINID"].ToString()) : 0;
op.GL_Code = reader["GL_Code"] != DBNull.Value ? reader["GL_Code"].ToString() : "null";
op.GL_Name = reader["GL_Name"] != DBNull.Value ? reader["GL_Name"].ToString() : "null";
op.Post_Date = reader["Post_Date"] != DBNull.Value ? reader["Post_Date"].ToString() : "null";
op.Amount = reader["Amount"] != DBNull.Value ? double.Parse(reader["Amount"].ToString()) : 0;
op.Description = reader["Description"] != DBNull.Value ? reader["Description"].ToString() : "null";
op.ChkMIS1 = reader["ChkMIS1"] != DBNull.Value ? reader["ChkMIS1"].ToString() : "null";
op.ChkMIS2 = reader["ChkMIS2"] != DBNull.Value ? reader["ChkMIS2"].ToString() : "null";
op.MIS_Code = reader["MIS_Code"] != DBNull.Value ? reader["MIS_Code"].ToString() : "null";
op.BranchCode = reader["BranchCode"] != DBNull.Value ? reader["BranchCode"].ToString() : "null";
op.TRANSID = reader["TRANSID"] != DBNull.Value ? reader["TRANSID"].ToString() : "null";
op.SUBGL = reader["SUBGL"] != DBNull.Value ? reader["SUBGL"].ToString() : "null";
op.SBUCODE = reader["SBUCODE"] != DBNull.Value ? reader["SBUCODE"].ToString() : "null";
op.Account = reader["Account"] != DBNull.Value ? reader["Account"].ToString() : "null";
op.Product = reader["Product"] != DBNull.Value ? reader["Product"].ToString() : "null";
}
con.Close();
}
return(op);
} //========== end of the mtd
} //========== end of the mtd
public IEnumerable <Models.RawExpensesFixedModel> GetAllRawExpensesFixedModelMtd_2(string svalue)
{
svalue = svalue.Replace("FORWARDSLASHXTER", "/");
svalue = svalue.Replace("DOTXTER", ".");
List <RawExpensesFixedModel> opexrawexpensesfixedList = new List <RawExpensesFixedModel>();
using (var con = new System.Data.SqlClient.SqlConnection(connectionString))
{
var cmd = new System.Data.SqlClient.SqlCommand("spp_RawExpensesFixed_2", con);
cmd.CommandType = System.Data.CommandType.StoredProcedure;
cmd.CommandTimeout = 0;
cmd.Parameters.Add(new SqlParameter
{
ParameterName = "SearchValue",
Value = svalue,
});
con.Open();
SqlDataReader reader = cmd.ExecuteReader();
while (reader.Read())
{
var op = new RawExpensesFixedModel();
op.FINID = reader["FINID"] != DBNull.Value ? int.Parse(reader["FINID"].ToString()) : 0;
op.GL_Code = reader["GL_Code"] != DBNull.Value ? reader["GL_Code"].ToString() : "null";
op.GL_Name = reader["GL_Name"] != DBNull.Value ? reader["GL_Name"].ToString() : "null";
op.Post_Date = reader["Post_Date"] != DBNull.Value ? reader["Post_Date"].ToString() : "null";
op.Amount = reader["Amount"] != DBNull.Value ? double.Parse(reader["Amount"].ToString()) : 0;
op.Description = reader["Description"] != DBNull.Value ? reader["Description"].ToString() : "null";
op.ChkMIS1 = reader["ChkMIS1"] != DBNull.Value ? reader["ChkMIS1"].ToString() : "null";
op.ChkMIS2 = reader["ChkMIS2"] != DBNull.Value ? reader["ChkMIS2"].ToString() : "null";
op.MIS_Code = reader["MIS_Code"] != DBNull.Value ? reader["MIS_Code"].ToString() : "null";
op.BranchCode = reader["BranchCode"] != DBNull.Value ? reader["BranchCode"].ToString() : "null";
op.TRANSID = reader["TRANSID"] != DBNull.Value ? reader["TRANSID"].ToString() : "null";
op.SUBGL = reader["SUBGL"] != DBNull.Value ? reader["SUBGL"].ToString() : "null";
opexrawexpensesfixedList.Add(op);
}
con.Close();
//System.Web.HttpContext.Current.Session["opexstaffexpdiff"] = opexstaffexpdiffList;
}
return(opexrawexpensesfixedList);
} //========== end of the mtd
} //========== end of the mtd
public void UpdateRawExpensesFixed(RawExpensesFixedModel updateopex)
{
using (var con = new System.Data.SqlClient.SqlConnection(connectionString))
{
var cmd = new System.Data.SqlClient.SqlCommand("spp_RawExpensesFixed_update", con);
cmd.CommandType = System.Data.CommandType.StoredProcedure;
cmd.CommandTimeout = 0;
//cmd.Parameters.Add("@result", System.Data.SqlDbType.TinyInt).Direction = System.Data.ParameterDirection.Output;
cmd.Parameters.Add(new SqlParameter
{
ParameterName = "id",
Value = updateopex.FINID,
});
cmd.Parameters.Add(new SqlParameter
{
ParameterName = "glcode",
Value = updateopex.GL_Code,
});
cmd.Parameters.Add(new SqlParameter
{
ParameterName = "glname",
Value = updateopex.GL_Name,
});
cmd.Parameters.Add(new SqlParameter
{
ParameterName = "mis_code",
Value = updateopex.MIS_Code,
});
cmd.Parameters.Add(new SqlParameter
{
ParameterName = "branchcode",
Value = updateopex.BranchCode,
});
cmd.Parameters.Add(new SqlParameter
{
ParameterName = "subgl",
Value = updateopex.SUBGL,
});
cmd.Parameters.Add(new SqlParameter
{
ParameterName = "sbucode",
Value = updateopex.SBUCODE,
});
cmd.Parameters.Add(new SqlParameter
{
ParameterName = "product",
Value = updateopex.Product,
});
cmd.Parameters.Add(new SqlParameter
{
ParameterName = "account",
Value = updateopex.Account,
});
con.Open();
cmd.ExecuteNonQuery();
con.Close();
}
}
public HttpResponseMessage UpdateRawExpensesFixed(HttpRequestMessage request, [FromBody] RawExpensesFixedModel updateopexmodel)
{
return(GetHttpResponse(request, () =>
{
OpexMtd obj = new OpexMtd();
obj.UpdateRawExpensesFixed(updateopexmodel);
return request.CreateResponse(HttpStatusCode.OK);
}));
}
