//Update MRP Database
public bool DALGRNStatus(LINKPayment objPayment)
{
bool status = false;
int GRNstatus = 9;
try
{
SqlConnection conn = DALConnManager.OpenMRP();
SqlCommand oSqlCommand = new SqlCommand();
string SqlQuery = "WCF_UpdateStatusGRN";
oSqlCommand.Connection = conn;
oSqlCommand.CommandText = SqlQuery;
oSqlCommand.CommandType = CommandType.StoredProcedure;
oSqlCommand.Parameters.AddWithValue("@Status", GRNstatus);
oSqlCommand.Parameters.AddWithValue("@GRNNo", objPayment.GRNNo);
status = new DALBase().Insert(oSqlCommand);
DALConnManager.Close(conn);
}
catch (Exception ex)
{
}
return(status);
}
public bool DALVoucherIDStatus(LINKPayment objPayment)
{
bool status = false;
int GRNstatus = 9;
try
{
SqlConnection conn = DALConnManager.OpenFinance();
SqlCommand oSqlCommand = new SqlCommand();
string SqlQuery = "WCF_UpdateStatustblVoucher";
oSqlCommand.Connection = conn;
oSqlCommand.CommandText = SqlQuery;
oSqlCommand.CommandType = CommandType.StoredProcedure;
oSqlCommand.Parameters.AddWithValue("@Status", GRNstatus);
oSqlCommand.Parameters.AddWithValue("@VoucherID", objPayment.VoucherID);
oSqlCommand.Parameters.AddWithValue("@ApproveDate", objPayment.ApproveDate);
status = new DALBase().Insert(oSqlCommand);
DALConnManager.Close(conn);
}
catch (Exception ex)
{
}
return(status);
}
public bool DALInsertInvoiceFromGRN(LINKPayment objPayment)
{
bool status = false;
try
{
SqlConnection conn = DALConnManager.OpenFinance();
SqlCommand oSqlCommand = new SqlCommand();
string SqlQuery = "WCF_PaymentInserIntoInvoiceFromGRN";
oSqlCommand.Connection = conn;
oSqlCommand.CommandText = SqlQuery;
oSqlCommand.CommandType = CommandType.StoredProcedure;
oSqlCommand.Parameters.AddWithValue("@InvoiceID", objPayment.InvoiceID);
oSqlCommand.Parameters.AddWithValue("@GRNNo", objPayment.GRNNo);
status = new DALBase().Insert(oSqlCommand);
DALConnManager.Close(conn);
}
catch (Exception ex)
{
}
return(status);
}
public bool DALInsertInvoice(LINKPayment objPayment)
{
bool status = false;
try
{
SqlConnection conn = DALConnManager.OpenFinance();
SqlCommand oSqlCommand = new SqlCommand();
string SqlQuery = "WCF_PaymentInserIntoInvoice";
oSqlCommand.Connection = conn;
oSqlCommand.CommandText = SqlQuery;
oSqlCommand.CommandType = CommandType.StoredProcedure;
oSqlCommand.Parameters.AddWithValue("@InvoiceID", objPayment.InvoiceID);
oSqlCommand.Parameters.AddWithValue("@ID", objPayment.ID);
oSqlCommand.Parameters.AddWithValue("@InvoiceDate", objPayment.InvoiceDate);
oSqlCommand.Parameters.AddWithValue("@Value", objPayment.Value);
oSqlCommand.Parameters.AddWithValue("@CreateDate", objPayment.CreateDate);
oSqlCommand.Parameters.AddWithValue("@CreateUser", objPayment.CreateUser);
oSqlCommand.Parameters.AddWithValue("@Modifieddate", objPayment.Modifieddate);
oSqlCommand.Parameters.AddWithValue("@ModifiedUser", objPayment.ModifiedUser);
oSqlCommand.Parameters.AddWithValue("@Status", objPayment.Status);
oSqlCommand.Parameters.AddWithValue("@SupplierID", objPayment.SupplierID);
status = new DALBase().Insert(oSqlCommand);
DALConnManager.Close(conn);
}
catch (Exception ex)
{
}
return(status);
}
public bool DALInsertVoucherFromInvoive(LINKPayment objPayment)
{
bool status = false;
try
{
SqlConnection conn = DALConnManager.OpenFinance();
SqlCommand oSqlCommand = new SqlCommand();
string SqlQuery = "WCF_PaymentInserIntoVoucherFromInvoice";
oSqlCommand.Connection = conn;
oSqlCommand.CommandText = SqlQuery;
oSqlCommand.CommandType = CommandType.StoredProcedure;
oSqlCommand.Parameters.AddWithValue("@VoucherID", objPayment.VoucherID);
oSqlCommand.Parameters.AddWithValue("@InvoiceID", objPayment.InvoiceID);
status = new DALBase().Insert(oSqlCommand);
DALConnManager.Close(conn);
}
catch (Exception ex)
{
//StreamWriter file2 = new StreamWriter(@"c:\file.txt", true);
//file2.WriteLine(ex.ToString() + "- " + DateTime.Now + "- DAL");
//file2.Close();
}
return(status);
}
//Unallocated --Connection oriented
public DataTable Select(string sql)
{
DataTable dt = new DataTable();
try
{
SqlConnection conn = DALConnManager.Open();
SqlCommand command = new SqlCommand(sql, conn);
SqlDataAdapter adp = new SqlDataAdapter(command);
adp.Fill(dt);
conn.Close();
}
catch (Exception ex)
{
throw;
}
return(dt);
}
//FOR Finance
public DataTable SelectSPFinance(SqlCommand oSqlCommand)
{
DataTable dt = new DataTable();
try
{
SqlConnection conn = DALConnManager.OpenFinance();
oSqlCommand.Connection = conn;
oSqlCommand.CommandType = CommandType.StoredProcedure;
SqlDataAdapter adp = new SqlDataAdapter(oSqlCommand);
adp.Fill(dt);
conn.Close();
}
catch (Exception ex)
{
throw;
}
return(dt);
}
public bool Update(string sql)
{
bool status = false;
int rowAffected = 0;
try
{
SqlConnection conn = DALConnManager.Open();
SqlCommand command = new SqlCommand(sql, conn);
rowAffected = command.ExecuteNonQuery();
DALConnManager.Close(conn);
if (rowAffected > 0)
{
status = true;
}
}
catch (SqlException ex)
{
throw;
}
return(status);
}
public bool UpdateMRP(SqlCommand oSqlCommand)
{
bool status = false;
int rowAffected = 0;
try
{
SqlConnection conn = DALConnManager.OpenMRP();
oSqlCommand.Connection = conn;
oSqlCommand.CommandType = CommandType.StoredProcedure;
rowAffected = oSqlCommand.ExecuteNonQuery();
DALConnManager.Close(conn);
if (rowAffected > 0)
{
status = true;
}
}
catch (SqlException ex)
{
throw;
}
return(status);
}
