public int UpdateChartOfAccount(ChartOfAccountEntity oChartOfAccountEntity)
{
con = oConnectionDatabase.DatabaseConnection();
try { con.Open(); }
catch { }
int i = 0;
//cmd = new SqlCommand("INSERT INTO tblCustomerImage (CustomerID,CustomerImage,CustomerSignature,Creatby,LastModifiedBy) VALUES('" + customerId + "','" + image + "','" + signature + "','" + Creatby + "','" + LastModifiedBy + "')", con);
cmd = new SqlCommand("UPDATE tblChartOfAccount SET CoAccName=@CoAccName,GrpAccSL=@GrpAccSL,AccGrpSLR=@AccGrpSLR,AccTypeSL=@AccTypeSL,SGrpAccSL=@SGrpAccSL,LastModifiedBy=@LastModifiedBy WHERE CoAccNo=@CoAccNo", con);
//cmd = new SqlCommand("INSERT INTO tblUserInfo (UserID,UserType,Password,ConfirmPassword,Active,LastModifiedBy) VALUES(@UserID,@UserType,@Password,@ConfirmPassword,@Active,@LastModifiedBy)", con);
cmd.Parameters.AddWithValue("@CoAccNo", SqlDbType.VarChar).Value = oChartOfAccountEntity.CoAccNo;
cmd.Parameters.AddWithValue("@CoAccName", SqlDbType.VarChar).Value = oChartOfAccountEntity.CoAccName;
cmd.Parameters.AddWithValue("@OpenDate", SqlDbType.VarChar).Value = oChartOfAccountEntity.OpenDate;
cmd.Parameters.AddWithValue("@GrpAccSL", SqlDbType.VarChar).Value = oChartOfAccountEntity.GrpAccSL;
cmd.Parameters.AddWithValue("@AccGrpSLR", SqlDbType.VarChar).Value = oChartOfAccountEntity.AccGrpSLR;
cmd.Parameters.AddWithValue("@AccTypeSL", SqlDbType.VarChar).Value = oChartOfAccountEntity.AccTypeSL;
cmd.Parameters.AddWithValue("@SGrpAccSL", SqlDbType.VarChar).Value = oChartOfAccountEntity.SGrpAccSL;
cmd.Parameters.AddWithValue("@Posted", SqlDbType.VarChar).Value = oChartOfAccountEntity.Posted;
cmd.Parameters.AddWithValue("@OpenDayBalance", SqlDbType.VarChar).Value = oChartOfAccountEntity.OpenDayBalance;
cmd.Parameters.AddWithValue("@ClossingBalance", SqlDbType.VarChar).Value = oChartOfAccountEntity.ClossingBalance;
cmd.Parameters.AddWithValue("@AvailableBalance", SqlDbType.VarChar).Value = oChartOfAccountEntity.AvailableBalance;
cmd.Parameters.AddWithValue("@CurrentBalance", SqlDbType.VarChar).Value = oChartOfAccountEntity.CurrentBalance;
cmd.Parameters.AddWithValue("@CreateBy", SqlDbType.VarChar).Value = oChartOfAccountEntity.CreateBy;
cmd.Parameters.AddWithValue("@LastModifiedBy", SqlDbType.VarChar).Value = oChartOfAccountEntity.LastModifiedBy;
try
{
cmd.CommandType = CommandType.Text;
cmd.ExecuteNonQuery();
i = 1;
}
catch { }
con.Close();
return(i);
}
public int DeleteChartOfAccount(ChartOfAccountEntity oChartOfAccountEntity)
{
con = oConnectionDatabase.DatabaseConnection();
int i = 0;
cmd = new SqlCommand("DELETE FROM tblChartOfAccount WHERE CoAccSL=" + oChartOfAccountEntity.CoAccSL, con);
try
{
cmd.CommandType = CommandType.Text;
cmd.ExecuteNonQuery();
i = 1;
}
catch { }
con.Close();
return(i);
}