/// <summary>
/// Saves a record to the P_AutoNumber table.
/// </summary>
public Boolean SaveP_AutoNumberSP(P_AutoNumber p_AutoNumber, int formMode)
{
SqlCommand scom;
bool retvalue = false;
try
{
scom = new SqlCommand();
scom.CommandType = CommandType.StoredProcedure;
scom.CommandText = "P_AutoNumberSave";
scom.Parameters.Add("@Screen", SqlDbType.VarChar, 50).Value = p_AutoNumber.Screen;
scom.Parameters.Add("@ID", SqlDbType.VarChar, 50).Value = p_AutoNumber.ID;
scom.Parameters.Add("@Serial", SqlDbType.Int, 4).Value = p_AutoNumber.Serial;
scom.Parameters.Add("@Mode", SqlDbType.Int, 4).Value = p_AutoNumber.Mode;
scom.Parameters.Add("@Prefix", SqlDbType.VarChar, 5).Value = p_AutoNumber.Prefix;
scom.Parameters.Add("@InsMode", SqlDbType.Int).Value = formMode; // For insert
scom.Parameters.Add("@RtnValue", SqlDbType.Int).Value = 0;
u_DBConnection dbcon = new u_DBConnection();
retvalue = dbcon.RunQuery(scom);
return(retvalue);
}
catch (Exception ex)
{
throw (ex);
}
}
public static void IncrementSerial(string screenname)
{
P_AutoNumberDL pal = new P_AutoNumberDL();
P_AutoNumber pauto = new P_AutoNumber();
pauto.Screen = screenname;
pauto = pal.Selectp_AutoNumber(pauto);
pauto.Serial += 1;
pal.SaveP_AutoNumberSP(pauto, 3);
}
public static string GetSerial(string screenname, string loca, string form)
{
string strserial = string.Empty;
P_AutoNumberDL pal = new P_AutoNumberDL();
P_AutoNumber pauto = new P_AutoNumber();
pauto.Screen = screenname;
pauto = pal.Selectp_AutoNumber(pauto);
decimal dec = (decimal)pauto.Serial;
dec += 1;
strserial = dec.ToString("00000000");
strserial = form.Trim().ToUpper() + "-" + loca.Trim() + "-" + strserial;
return(strserial);
}
public P_AutoNumber Selectp_AutoNumber(P_AutoNumber objp_AutoNumber)
{
try
{
strquery = @"SELECT * FROM P_AutoNumber where Screen = '" + objp_AutoNumber.Screen.Trim() + "'";
DataRow drType = u_DBConnection.ReturnDataRow(strquery);
if (drType != null)
{
objp_AutoNumber.Screen = drType["Screen"].ToString();
objp_AutoNumber.ID = drType["ID"].ToString();
objp_AutoNumber.Serial = int.Parse(drType["Serial"].ToString());
objp_AutoNumber.Mode = int.Parse(drType["Mode"].ToString());
objp_AutoNumber.Prefix = drType["Prefix"].ToString();
return(objp_AutoNumber);
}
return(null);
}
catch (Exception ex)
{
throw ex;
}
}
/// <summary>
/// Get the 4 method specific serials
/// 1. Entirely system generated only digit serial numbers
/// 2. System generated formatted serial numbers
/// 3. Entirely manual serial numbers
/// 4. location and prefix specific serial numbers
/// </summary>
/// <param name="screenname">Screen Name Like A0001</param>
/// <returns></returns>
public static string GetSerial(string screenname)
{
string strserial = string.Empty;
P_AutoNumberDL pal = new P_AutoNumberDL();
P_AutoNumber pauto = new P_AutoNumber();
pauto.Screen = screenname;
pauto = pal.Selectp_AutoNumber(pauto);
if (pauto.Mode == 1)
{
decimal dec = (decimal)pauto.Serial;
dec += 1;
strserial = dec.ToString("0000000000");
}
else if (pauto.Mode == 2)
{
decimal dec = (decimal)pauto.Serial;
dec += 1;
strserial = dec.ToString("0000000000");
strserial = pauto.Prefix.Trim() + "-" + strserial;
}
else if (pauto.Mode == 3)
{
strserial = "";
}
else if (pauto.Mode == 4)
{
decimal dec = (decimal)pauto.Serial;
dec += 1;
strserial = dec.ToString("0000000000");
strserial = pauto.Prefix.Trim() + "-" + commonFunctions.GlobalLocation.Trim().ToUpper() + "-" + strserial;
}
return(strserial);
}
