public static bool Save(User objUser, User currentUser)
{
int result = 0;
UserCompany CurrentCompany = new UserCompany();
string strSaveQry, strEncryptPwd;
if (objUser.IsNew)
{
strSaveQry = "Insert into UserProfile (DBID, FIRSTNAME, LOGINNAME, PASSWORD, ROLE, " +
" BRANCHCODE, COMPANYCODE, ST_DATE, MODIFY_DATE, DEPT, ISACTIVE, DEPTHEAD, CRBY, MODBY, MACHINENAME) " +
" VALUES ( @dbid, @FirstName, @LoginName, @Password, @Role, " +
" @BranchCode, @CompanyCode, @StDate, @ModifyDate, @Dept, @IsActive, @DeptHead, " +
" @CrBy, @ModBy, @MachineName)";
}
else
{
strSaveQry = "UPDATE UserProfile " +
"set FIRSTNAME = @FirstName, LOGINNAME = @LoginName, PASSWORD = @Password, " +
" ROLE = @Role, BRANCHCODE = @BranchCode, COMPANYCODE = @CompanyCode, " +
" MODIFY_DATE = @ModifyDate, DEPT = @Dept, ISACTIVE = @IsActive, DEPTHEAD = @DeptHead, " +
" MODBY = @ModBy, MACHINENAME = @MachineName " +
" WHERE DBID = @dbid ";
}
SqlConnection Conn = new SqlConnection(General.GetSQLConnectionString());
SqlCommand objCmd = new SqlCommand();
try
{
// Temporary disabled as stored procedure is not created.
//strEncryptPwd = GetEncryptPwd(objUser.Password);
strEncryptPwd = objUser.Password;
objCmd.Connection = Conn;
objCmd.CommandType = CommandType.Text;
objCmd.CommandText = strSaveQry;
objCmd.Parameters.AddWithValue("@dbid", objUser.DBID);
objCmd.Parameters.AddWithValue("@FirstName", objUser.FirstName);
objCmd.Parameters.AddWithValue("@LoginName", objUser.LoginName);
objCmd.Parameters.AddWithValue("@Password", strEncryptPwd);
objCmd.Parameters.AddWithValue("@Role", objUser.Role);
objCmd.Parameters.AddWithValue("@BranchCode", objUser.BranchCode);
objCmd.Parameters.AddWithValue("@CompanyCode", objUser.CompanyCode);
if (objUser.IsNew)
{
objCmd.Parameters.AddWithValue("@StDate", DateTime.Now);
objCmd.Parameters.AddWithValue("@CrBy", currentUser.LoginName);
objUser.DBID = GenerateDBID();
}
objCmd.Parameters.AddWithValue("@ModifyDate", DateTime.Now);
objCmd.Parameters.AddWithValue("@ModBy", currentUser.LoginName);
objCmd.Parameters.AddWithValue("@MachineName", General.GetMachineName());
objCmd.Parameters.AddWithValue("@Dept", objUser.Dept);
objCmd.Parameters.AddWithValue("@IsActive", objUser.IsActive);
objCmd.Parameters.AddWithValue("@DeptHead", objUser.DeptHead);
if (Conn.State != ConnectionState.Open)
{
Conn.Open();
}
result = objCmd.ExecuteNonQuery();
objCmd.Dispose();
}
catch (Exception ex)
{
throw new Exception(ex.Message);
}
finally
{
Conn.Close();
Conn.Dispose();
}
return(result > 0);
}
/// <summary>
/// This method Saves Record into Database.
/// </summary>
/// <param name="objRetDC">Object containing Data values to be saved.</param>
/// <returns>Boolean value True if Record is saved successfully
/// otherwise returns False indicating Record is not saved.</returns>
public static bool Save(ReturnableDC objRetDC, User currentUser)
{
int result = 0;
UserCompany CurrentCompany = new UserCompany();
using (SqlConnection Conn = new SqlConnection(General.GetSQLConnectionString()))
{
string strSaveQry;
if (objRetDC.IsNew)
{
strSaveQry = "INSERT INTO RETURNABLEDC(DBID, ENTRYNO, ENTRYDATE, ENTRYTYPE, " +
" PARTYNAME, VEHICLENO, DCNO, DCDATE, PLANT, VINDATE, VINTIME, VOUTDATE, " +
" VOUTTIME, ST_DATE, MODIFY_DATE, CRBY, MODBY, MACHINENAME) " +
" VALUES (@dbId, @EntryNo, @EntryDate, @EntryType, @PartyName, @VehicleNo, " +
" @DCNo, @DCDate, @Plant, @VinDate, @VinTime, @VOutDate, @VoutTime, " +
" @STDate, @ModifyDate, @CrBy, @ModBy, @MachineName)";
}
else
{
strSaveQry = "UPDATE RETURNABLEDC " +
" SET ENTRYNO = @EntryNo, ENTRYDATE = @EntryDate, ENTRYTYPE = @EntryType, " +
" PARTYNAME = @PartyName, VEHICLENO = @VehicleNo, DCNO = @DCNo, " +
" DCDATE = @DCDate, PLANT = @Plant, VINDATE = @VInDate, VINTIME = @VInTime, " +
" VOUTDATE = @VOutDate, VOUTTIME = @VOutTime, MODIFY_DATE = @ModifyDate, " +
" MODBY = @ModBy, MACHINENAME = @MachineName " +
" WHERE DBID = @dbId";
}
try
{
SqlCommand objCmd = Conn.CreateCommand();
objCmd.CommandType = CommandType.Text;
objCmd.CommandText = strSaveQry;
objCmd.Parameters.AddWithValue("@EntryDate", objRetDC.EntryDate);
objCmd.Parameters.AddWithValue("@EntryType", objRetDC.EntryType);
objCmd.Parameters.AddWithValue("@PartyName", objRetDC.PartyName);
if (objRetDC.VehicleNo == string.Empty)
{
objCmd.Parameters.AddWithValue("@VehicleNo", DBNull.Value);
}
else
{
objCmd.Parameters.AddWithValue("@VehicleNo", objRetDC.VehicleNo);
}
objCmd.Parameters.AddWithValue("@DCNo", objRetDC.DCNo);
objCmd.Parameters.AddWithValue("@DCDate", objRetDC.DCDate);
objCmd.Parameters.AddWithValue("@Plant", objRetDC.PlantName);
if (objRetDC.VInDate == DateTime.MinValue)
{
objCmd.Parameters.AddWithValue("@VInDate", DBNull.Value);
}
else
{
objCmd.Parameters.AddWithValue("@VInDate", objRetDC.VInDate);
}
if (objRetDC.VInTime == DateTime.MinValue)
{
objCmd.Parameters.AddWithValue("@VInTime", DBNull.Value);
}
else
{
objCmd.Parameters.AddWithValue("@VInTime", objRetDC.VInTime);
}
if (objRetDC.VOutDate == DateTime.MinValue)
{
objCmd.Parameters.AddWithValue("@VOutDate", DBNull.Value);
}
else
{
objCmd.Parameters.AddWithValue("@VOutDate", objRetDC.VOutDate);
}
if (objRetDC.VOutTime == DateTime.MinValue)
{
objCmd.Parameters.AddWithValue("@VOutTime", DBNull.Value);
}
else
{
objCmd.Parameters.AddWithValue("@VOutTime", objRetDC.VOutTime);
}
if (objRetDC.IsNew)
{
objCmd.Parameters.AddWithValue("@StDate", DateTime.Now);
objCmd.Parameters.AddWithValue("@CrBy", currentUser.LoginName);
//objRetDC.DBID = General.GenerateDBID(Conn, "RETURNABLEDC");
objRetDC.DBID = General.GenerateDBID("SEQDCID", Conn);
objRetDC.EntryNo = objRetDC.DBID;
}
objCmd.Parameters.AddWithValue("@ModifyDate", DateTime.Now);
objCmd.Parameters.AddWithValue("@ModBy", currentUser.LoginName);
objCmd.Parameters.AddWithValue("@MachineName", General.GetMachineName());
objCmd.Parameters.AddWithValue("@dbID", objRetDC.DBID);
objCmd.Parameters.AddWithValue("@EntryNo", objRetDC.EntryNo);
if (Conn.State != ConnectionState.Open)
{
Conn.Open();
}
result = objCmd.ExecuteNonQuery();
}
catch (Exception ex)
{
throw ex;
}
}
return(result > 0);
}
